APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 5311: AHL_WORKORDER_MTL_TXNS mtxn

5307: IS
5308: Cursor get_issued_quantity_csr(p_disp_id IN NUMBER) IS
5309: SELECT sum (assoc.quantity)
5310: FROM AHL_PRD_DISP_MTL_TXNS assoc,
5311: AHL_WORKORDER_MTL_TXNS mtxn
5312: WHERE assoc.disposition_id = p_disp_id
5313: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
5314: AND mtxn.transaction_type_id = WIP_CONSTANTS.ISSCOMP_TYPE
5315: GROUP BY assoc.disposition_id;