DBA Data[Home] [Help]

APPS.PJM_INQUIRY dependencies on MTL_SYSTEM_ITEMS_KFV

Line 93: --with mtl_system_items_kfv/CONCATENATED_SEGMENTS (varchar40 as well).

89:
90: BEGIN
91:
92: --Bug 13023056 item number not shows fully in project inquiry screen, replace the MTL_SYSTEM_ITEMS_B/segment1
93: --with mtl_system_items_kfv/CONCATENATED_SEGMENTS (varchar40 as well).
94: SELECT CONCATENATED_SEGMENTS into L_Item_Number
95: from mtl_system_items_kfv
96: where inventory_item_id = X_Item_Id
97: and organization_id = X_Organization_Id;

Line 95: from mtl_system_items_kfv

91:
92: --Bug 13023056 item number not shows fully in project inquiry screen, replace the MTL_SYSTEM_ITEMS_B/segment1
93: --with mtl_system_items_kfv/CONCATENATED_SEGMENTS (varchar40 as well).
94: SELECT CONCATENATED_SEGMENTS into L_Item_Number
95: from mtl_system_items_kfv
96: where inventory_item_id = X_Item_Id
97: and organization_id = X_Organization_Id;
98:
99: RETURN ( L_Item_Number );