APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on AHL_WORKORDER_MTL_TXNS

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 76: FROM AHL_WORKORDER_MTL_TXNS

72: WHERE WORKORDER_MTL_TXN_ID = p_mtl_txn_id;
73: --
74: CURSOR get_mtl_txn_qty_csr (p_mtl_txn_id IN NUMBER) IS
75: SELECT inventory_item_id, quantity, uom
76: FROM AHL_WORKORDER_MTL_TXNS
77: WHERE WORKORDER_MTL_TXN_ID = p_mtl_txn_id;
78: --
79: CURSOR get_disp_qty_csr (p_disposition_id IN NUMBER) IS
80: SELECT disp.quantity

Line 681: FROM AHL_WORKORDER_MTL_TXNS txn, AHL_WORKORDER_OPERATIONS oper,

677: SELECT oper.workorder_id, txn.transaction_type_id,
678: txn.inventory_item_id, txn.organization_id,
679: txn.serial_number, txn.lot_number,
680: NVL(mtl.comms_nl_trackable_flag,'N') trackable_flag
681: FROM AHL_WORKORDER_MTL_TXNS txn, AHL_WORKORDER_OPERATIONS oper,
682: mtl_system_items_kfv mtl
683: WHERE txn.workorder_mtl_txn_id = p_mtl_txn_id
684: AND txn.workorder_operation_id = oper.workorder_operation_id
685: AND txn.inventory_item_id = mtl.inventory_item_id

Line 1071: AHL_WORKORDER_MTL_TXNS mtxn

1067: CURSOR get_remain_qty_csr(p_disp_id IN NUMBER)
1068: IS
1069: SELECT sum (assoc.quantity)
1070: FROM AHL_PRD_DISPOSITIONS_B disp, AHL_PRD_DISP_MTL_TXNS assoc,
1071: AHL_WORKORDER_MTL_TXNS mtxn
1072: WHERE disp.disposition_id = p_disp_id
1073: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
1074: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)
1075: AND disp.disposition_id = assoc.disposition_id

Line 1111: AHL_WORKORDER_MTL_TXNS mtxn

1107: CURSOR get_assoc_qty_csr(p_disp_id IN NUMBER, p_workorder_txn_id IN NUMBER)
1108: IS
1109: SELECT sum (assoc.quantity)
1110: FROM AHL_PRD_DISPOSITIONS_B disp, AHL_PRD_DISP_MTL_TXNS assoc,
1111: AHL_WORKORDER_MTL_TXNS mtxn
1112: WHERE disp.disposition_id = p_disp_id
1113: AND assoc.workorder_mtl_txn_id = p_workorder_txn_id
1114: AND assoc.workorder_mtl_txn_id = mtxn.workorder_mtl_txn_id
1115: AND mtxn.transaction_type_id = decode (disp.immediate_disposition_code,'NOT_RECEIVED',WIP_CONSTANTS.ISSCOMP_TYPE,WIP_CONSTANTS.RETCOMP_TYPE)