DFF Query

SELECT DFF.descriptive_flexfield_name "FEILD NAME"

      ,dffC.application_id

      ,DFFC.application_column_name "COLUMN"

      ,DFFC.descriptive_flex_context_code "CODE"

      ,DFFC.end_user_column_name "NAME"

      , dff.application_table_name "TABLE"

      

FROM  FND_DESCRIPTIVE_FLEXS DFF,

      FND_DESCR_FLEX_COLUMN_USAGES DFFC

WHERE DFF.application_id = dffc.application_id

AND DFFC.application_id = '660'

AND dff.descriptive_flexfield_name = 'OE_HEADER_ATTRIBUTES'

AND dffc.end_user_column_name = 'Old OrderNumber'

3.       Write A PROCEDURE

CREATE OR REPLACE PROCEDURE XXATTRIBUTE1 (ERRBUFF OUT VARCHAR2, RETCODE OUT NUMBER)

AS

CURSOR C1

IS

SELECT DFF.descriptive_flexfield_name "FEILD_NAME"

      ,dffc.application_id

      ,DFFC.application_column_name "COLUMN"

      ,DFFC.descriptive_flex_context_code "CODE"

      ,DFFC.end_user_column_name "NAME"

      , dff.application_table_name "TABLE"

      

FROM  FND_DESCRIPTIVE_FLEXS DFF,

      FND_DESCR_FLEX_COLUMN_USAGES DFFC

WHERE DFF.application_id = dffc.application_id

AND DFFC.application_id = '660'

AND dff.descriptive_flexfield_name = 'OE_HEADER_ATTRIBUTES'

AND dffc.end_user_column_name = 'Old OrderNumber';

 X C1%ROWTYPE;

 BEGIN

 FOR X IN C1 LOOP

FND_FILE.put_line(FND_FILE.OUTPUT,'FEILD NAME' ||'-'|| X.FEILD_NAME);

FND_FILE.put_line(FND_FILE.OUTPUT,'CODE' ||'-'|| X.CODE);

FND_FILE.put_line(FND_FILE.OUTPUT,'COLUMN' ||'-'|| X.COLUMN);

FND_FILE.put_line(FND_FILE.OUTPUT,'NAME' ||'-'|| X.NAME);

 end loop;

 commit;

 end;