APPS.INV_INVTOPKL_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 696: MTL_SYSTEM_ITEMS_B

692: SELECT
693: TRACKING_QUANTITY_IND
694: INTO L_TRACK_IND
695: FROM
696: MTL_SYSTEM_ITEMS_B
697: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
698: AND ORGANIZATION_ID = P_ORG_ID;
699: IF (L_TRACK_IND = 'PS') THEN
700: L_SEC_QTY := SEC_TRANSACTION_QTY;

Line 717: MTL_SYSTEM_ITEMS_B

713: SELECT
714: TRACKING_QUANTITY_IND
715: INTO L_TRACK_IND
716: FROM
717: MTL_SYSTEM_ITEMS_B
718: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
719: AND ORGANIZATION_ID = P_ORG_ID;
720: IF (L_TRACK_IND = 'PS') THEN
721: L_SEC_UOM := SEC_UOM;

Line 740: MTL_SYSTEM_ITEMS_B

736: SELECT
737: TRACKING_QUANTITY_IND
738: INTO L_TRACK_IND
739: FROM
740: MTL_SYSTEM_ITEMS_B
741: WHERE INVENTORY_ITEM_ID = PARENT_ITEM_ID
742: AND ORGANIZATION_ID = P_ORG_ID;
743: IF (L_TRACK_IND = 'PS') THEN
744: L_PARENT_SEC_UOM := PARENT_SEC_TXN_UOM;

Line 763: MTL_SYSTEM_ITEMS_B

759: SELECT
760: TRACKING_QUANTITY_IND
761: INTO L_TRACK_IND
762: FROM
763: MTL_SYSTEM_ITEMS_B
764: WHERE INVENTORY_ITEM_ID = PARENT_ITEM_ID
765: AND ORGANIZATION_ID = P_ORG_ID;
766: IF (L_TRACK_IND = 'PS') THEN
767: L_PARENT_SEC_QTY := PARENT_SEC_TXN_QTY;