DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on FND_PROFILE

Line 2028: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',

2024: FROM hz_parties a,
2025: hz_cust_accounts b
2026: WHERE a.party_id = b.party_id
2027: AND b.cust_account_id = lc.cust_acct_id) party_name,
2028: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',
2029: B.CONCATENATED_SEGMENTS ,T.DESCRIPTION )
2030: FROM MTL_SYSTEM_ITEMS_B_KFV B,
2031: MTL_SYSTEM_ITEMS_TL T
2032: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID

Line 2071: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',

2067: FROM hz_parties a,
2068: hz_cust_accounts b
2069: WHERE a.party_id = b.party_id
2070: AND b.cust_account_id = lc.cust_acct_id) party_name,
2071: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',
2072: B.CONCATENATED_SEGMENTS ,T.DESCRIPTION )
2073: FROM MTL_SYSTEM_ITEMS_B_KFV B,
2074: MTL_SYSTEM_ITEMS_TL T
2075: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID