DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2030: FROM MTL_SYSTEM_ITEMS_B_KFV 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
2033: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
2034: AND T.LANGUAGE = userenv('LANG')

Line 2073: FROM MTL_SYSTEM_ITEMS_B_KFV 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
2076: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
2077: AND T.LANGUAGE = userenv('LANG')