APPS.INV_TRX_RELIEF_C_PVT dependencies on MTL_SYSTEM_ITEMS

Line 930: from mtl_system_items

926:
927: -- INVCONV BEGIN
928: CURSOR l_tracking_qty_cur IS
929: select tracking_quantity_ind
930: from mtl_system_items
931: where organization_id = p_organization_id and inventory_item_id = p_inventory_item_id;
932: -- INVCONV END
933:
934: /* CURSOR l_rsv_cur2 IS

Line 1813: FROM MTL_SYSTEM_ITEMS C,

1809: ABS(NVL(B.PRIMARY_QUANTITY,0)),
1810: A.PRIMARY_QUANTITY *(-1)) PRIMARY_QUANTITY,
1811: A.TRANSACTION_SOURCE_NAME,
1812: FND_DATE.DATE_TO_CANONICAL(A.TRANSACTION_DATE) TRANSACTION_DATE
1813: FROM MTL_SYSTEM_ITEMS C,
1814: MTL_TRANSACTION_LOTS_TEMP B,
1815: MTL_MATERIAL_TRANSACTIONS_TEMP A
1816: WHERE A.TRANSACTION_HEADER_ID = p_transaction_header_id
1817: AND A.ORGANIZATION_ID = C.ORGANIZATION_ID