APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 58: FROM AHL_WORKORDER_MTL_TXNS mt, AHL_WORKORDER_OPERATIONS wop

54:
55: CURSOR get_mtl_txn_rec_csr (p_mtl_txn_id IN NUMBER) IS
56: SELECT mt.transaction_type_id, mt.inventory_item_id, mt.organization_id,
57: mt.quantity, mt.uom, wop.workorder_id
58: FROM AHL_WORKORDER_MTL_TXNS mt, AHL_WORKORDER_OPERATIONS wop
59: WHERE mt.WORKORDER_MTL_TXN_ID = p_mtl_txn_id
60: AND wop.workorder_operation_id = mt.workorder_operation_id;
61: --
62: CURSOR get_disp_mtl_txn_rec_csr (p_disposition_id IN NUMBER,

Line 693: FROM AHL_WORKORDER_MTL_TXNS txn, AHL_WORKORDER_OPERATIONS oper,

689: SELECT oper.workorder_id, txn.transaction_type_id,
690: txn.inventory_item_id, txn.organization_id,
691: txn.serial_number, txn.lot_number,
692: NVL(mtl.comms_nl_trackable_flag,'N') trackable_flag
693: FROM AHL_WORKORDER_MTL_TXNS txn, AHL_WORKORDER_OPERATIONS oper,
694: mtl_system_items_kfv mtl
695: WHERE txn.workorder_mtl_txn_id = p_mtl_txn_id
696: AND txn.workorder_operation_id = oper.workorder_operation_id
697: AND txn.inventory_item_id = mtl.inventory_item_id