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 1816: FROM MTL_SYSTEM_ITEMS C,

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