APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_PRD_DISP_MTL_TXNS

Line 131: ahl_prd_disp_mtl_txns DM

127: DM.uom uom,
128: sum(DM.quantity) quantity,
129: count(MT.transaction_type_id) rec_no
130: FROM ahl_workorder_mtl_txns MT,
131: ahl_prd_disp_mtl_txns DM
132: WHERE DM.disposition_id = c_disposition_id
133: AND MT.workorder_mtl_txn_id = DM.workorder_mtl_txn_id
134: GROUP BY MT.transaction_type_id, DM.uom
135: HAVING MT.transaction_type_id IN (G_ISSUE_ID, G_RETURN_ID);

Line 146: ahl_prd_disp_mtl_txns DM,

142: MT.lot_number lot_number,
143: DM.quantity quantity,
144: DM.uom uom
145: FROM ahl_workorder_mtl_txns MT,
146: ahl_prd_disp_mtl_txns DM,
147: mtl_system_items_kfv IV
148: WHERE DM.disposition_id = c_disposition_id
149: AND MT.workorder_mtl_txn_id = DM.workorder_mtl_txn_id
150: AND MT.transaction_type_id = c_txn_type_id