DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on FND_LOOKUPS

Line 813: FND_LOOKUPS lookups

809: SYSDATE,
810: FND_GLOBAL.CONC_LOGIN_ID,
811: 1
812: FROM
813: FND_LOOKUPS lookups
814: WHERE
815: lookups.LOOKUP_TYPE = 'JLZZ_AR_TX_FISCAL_CLASS_CODE'
816: AND NOT EXISTS -- this condition makes sure we dont duplicate data
817: (select NULL from ZX_FC_CODES_B Codes where

Line 3869: FROM FND_LOOKUPS lookups

3865: SYSDATE,
3866: FND_GLOBAL.CONC_LOGIN_ID,
3867: 1
3868:
3869: FROM FND_LOOKUPS lookups
3870: WHERE
3871:
3872: lookups.lookup_type='JLCL_AP_DOCUMENT_TYPE'
3873: AND NOT EXISTS -- this condition makes sure we dont duplicate data

Line 4176: FROM FND_LOOKUPS lookups

4172: (SELECT
4173: lookups.LOOKUP_CODE fc_code,
4174: nvl(START_DATE_ACTIVE,to_date('01/01/1951','DD/MM/YYYY')) effective_from,
4175: END_DATE_ACTIVE effective_to
4176: FROM FND_LOOKUPS lookups
4177: WHERE
4178: (lookups.LOOKUP_TYPE = 'TRANSACTION_CLASS' or
4179: lookups.LOOKUP_TYPE = 'TRANSACTION_REASON')
4180: ) lookups