APPS.INV_INVTOPKL_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 705: MTL_SYSTEM_ITEMS_B

701: SELECT
702: TRACKING_QUANTITY_IND
703: INTO L_TRACK_IND
704: FROM
705: MTL_SYSTEM_ITEMS_B
706: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
707: AND ORGANIZATION_ID = P_ORG_ID;
708: IF (L_TRACK_IND = 'PS') THEN
709: L_SEC_QTY := SEC_TRANSACTION_QTY;

Line 726: MTL_SYSTEM_ITEMS_B

722: SELECT
723: TRACKING_QUANTITY_IND
724: INTO L_TRACK_IND
725: FROM
726: MTL_SYSTEM_ITEMS_B
727: WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
728: AND ORGANIZATION_ID = P_ORG_ID;
729: IF (L_TRACK_IND = 'PS') THEN
730: L_SEC_UOM := SEC_UOM;

Line 749: MTL_SYSTEM_ITEMS_B

745: SELECT
746: TRACKING_QUANTITY_IND
747: INTO L_TRACK_IND
748: FROM
749: MTL_SYSTEM_ITEMS_B
750: WHERE INVENTORY_ITEM_ID = PARENT_ITEM_ID
751: AND ORGANIZATION_ID = P_ORG_ID;
752: IF (L_TRACK_IND = 'PS') THEN
753: L_PARENT_SEC_UOM := PARENT_SEC_TXN_UOM;

Line 772: MTL_SYSTEM_ITEMS_B

768: SELECT
769: TRACKING_QUANTITY_IND
770: INTO L_TRACK_IND
771: FROM
772: MTL_SYSTEM_ITEMS_B
773: WHERE INVENTORY_ITEM_ID = PARENT_ITEM_ID
774: AND ORGANIZATION_ID = P_ORG_ID;
775: IF (L_TRACK_IND = 'PS') THEN
776: L_PARENT_SEC_QTY := PARENT_SEC_TXN_QTY;