DIFFERENT TYPES OF DATATYPES IN PYTHON

Integer - Stores natural numbers ( +-1 etc )

Long - Stores large natural numbers ( +-12343545337970680238406804 etc )

Float - Stores decimal numbers ( +- 1.3443 )

String - stores character values ( 'abc' )

Dictionary - stores key value pair combination information ( {a:1,b:2} )

Complex - it stores complex numbers which are combination of numeric and string values ( 2+9j )

Set - stores unique set of values (set(1,2,3)  =[1,2,3])

Boolean - It stores True or false values

List - stores list of values ( [1,2,3,4,5,6,5,6] )

Tuple - stores list of  constant values that will never be changed ( tuple(1,2,3,4,5) =[1,2,3,4,5] )

EBS QUERY TO FIND DFF INFORMATION

Below EBS query gives the DFF information, Enter the table name for which you want the DFF information.

SELECT ffv.descriptive_flexfield_name "DFF Name",
ffv.application_table_name "Table Name",
ffv.title "Title",
ap.application_name "Application",
ffc.descriptive_flex_context_code "Context Code",
ffc.descriptive_flex_context_name "Context Name",
ffc.description "Context Desc",
ffc.enabled_flag "Context Enable Flag",
att.column_seq_num "Segment Number",
att.form_left_prompt "Segment Name",
att.application_column_name "Column",
fvs.flex_value_set_name "Value Set",
att.display_flag "Displayed",
att.enabled_flag "Enabled",
att.required_flag "Required"
FROM apps.fnd_descriptive_flexs_vl ffv,
apps.fnd_descr_flex_contexts_vl ffc,
apps.fnd_descr_flex_col_usage_vl att,
apps.fnd_flex_value_sets fvs,
apps.fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = att.descriptive_flexfield_name
AND ap.application_id=ffv.application_id
AND ffv.descriptive_flexfield_name = ffc.descriptive_flexfield_name
AND ffv.application_id = ffc.application_id
AND ffc.descriptive_flex_context_code=att.descriptive_flex_context_code
AND fvs.flex_value_set_id=att.flex_value_set_id
--AND ffv.application_table_name like 'Table Name' 
--AND ffv.title like 'Give Title Name'
--AND ffc.descriptive_flex_context_code like 'Give Context Code Value'