DBA Data[Home] [Help]

APPS.JL_JLBRRINV_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 217: MTL_SYSTEM_ITEMS.SEGMENT1

213: X_ITEM_CODE := NULL;
214: BEGIN
215: IF C_INVENTORY_ID IS NOT NULL THEN
216: SELECT
217: MTL_SYSTEM_ITEMS.SEGMENT1
218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID

Line 220: MTL_SYSTEM_ITEMS

216: SELECT
217: MTL_SYSTEM_ITEMS.SEGMENT1
218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID
222: AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = H_SO_ORGANIZATION;
223: END IF;
224: EXCEPTION

Line 221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID

217: MTL_SYSTEM_ITEMS.SEGMENT1
218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID
222: AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = H_SO_ORGANIZATION;
223: END IF;
224: EXCEPTION
225: WHEN OTHERS THEN

Line 222: AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = H_SO_ORGANIZATION;

218: INTO X_ITEM_CODE
219: FROM
220: MTL_SYSTEM_ITEMS
221: WHERE MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID = C_INVENTORY_ID
222: AND MTL_SYSTEM_ITEMS.ORGANIZATION_ID = H_SO_ORGANIZATION;
223: END IF;
224: EXCEPTION
225: WHEN OTHERS THEN
226: NULL;