Learn about DFF - How to register the DFF for a custom table

Sdílet
Vložit
  • čas přidán 5. 09. 2024
  • Learn about DFF - How to register the DFF for a custom table
    BEGIN
    AD_DD.REGISTER_TABLE('FND','XXWIP_MOVE_EXTRACT_E531','T');
    END;
    BEGIN
    AD_DD.REGISTER_COLUMN( 'FND', 'XXWIP_MOVE_EXTRACT_E531', 'MOVE_TRANSACTION_ID', 1 ,'NUMBER', 22 ,'N', 'N')
    end;
    SELECT
    'AD_DD.REGISTER_COLUMN( '‘XXINV'','''
    ||table_name
    || ''','''
    ||COLUMN_NAME
    ||''','''
    ||COLUMN_ID
    ||''','''
    ||DATA_TYPE
    ||''','
    ||DATA_LENGTH
    ||',''N'','
    ||'''N'');' AS TEXT
    FROM
    ALL_TAB_COLUMNS
    WHERE
    table_name LIKE 'XXWIP_MOVE_EXTRACT_TBL'
    ORDER BY
    COLUMN_ID
    -----
    fnd_descriptive_flexs_vl || DESCRIPTIVE_FLEXFIELD_NAME
    fnd_descr_flex_contexts_vl || DESCRIPTIVE_FLEXFIELD_NAME
    fnd_descr_flex_col_usage_vl || DESCRIPTIVE_FLEXFIELD_NAME

Komentáře •