Saturday, August 7, 2010

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;

No comments:

Post a Comment