Learn about DFF - How to register the DFF for a custom table
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