DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 2031: MTL_SYSTEM_ITEMS_TL T

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')
2035: AND B.INVENTORY_ITEM_ID = object1_id1

Line 2074: MTL_SYSTEM_ITEMS_TL T

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')
2078: AND B.INVENTORY_ITEM_ID = object1_id1