DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 130: FROM ahl_workorder_mtl_txns MT,

126: SELECT MT.transaction_type_id transaction_type_id,
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

Line 145: FROM ahl_workorder_mtl_txns MT,

141: MT.serial_number serial_number,
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