APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 4851: AHL_WORKORDER_MTL_TXNS mtxn

4847: IS
4848: Cursor get_issued_quantity_csr(p_disp_id IN NUMBER) IS
4849: SELECT sum (assoc.quantity)
4850: FROM AHL_PRD_DISP_MTL_TXNS assoc,
4851: AHL_WORKORDER_MTL_TXNS mtxn
4852: WHERE assoc.disposition_id = p_disp_id
4853: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
4854: AND mtxn.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE
4855: GROUP BY assoc.disposition_id;