APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on AHL_PRD_DISPOSITIONS_B

Line 40: FROM AHL_PRD_DISPOSITIONS_B disp

36: CURSOR get_disp_rec_csr (p_disposition_id IN NUMBER) IS
37: SELECT disp.disposition_id, disp.object_version_number,
38: disp.inventory_item_id, disp.organization_id,
39: disp.immediate_disposition_code, disp.quantity, disp.UOM, disp.workorder_id
40: FROM AHL_PRD_DISPOSITIONS_B disp
41: WHERE disp.disposition_id = p_disposition_id;
42:
43: -- Change made by jaramana on August 8, 2007 for bug 6326065 (FP of 6061600)
44: -- Start allowing Disp Txn association for Complete workorders (code 4)

Line 81: FROM AHL_PRD_DISPOSITIONS_B disp

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
81: FROM AHL_PRD_DISPOSITIONS_B disp
82: WHERE disp.disposition_id = p_disposition_id;
83: --
84: l_old_disp_mx_rec get_disp_mtl_txn_rec_csr%ROWTYPE;
85: l_disp_mx_rec AHL_PRD_DISP_MTL_TXN_PVT.disp_mtl_txn_rec_type;

Line 894: FROM ahl_prd_dispositions_b A

890:
891: --Added by Jerry for fixing bug 4092624
892: CURSOR check_issue_items(c_disposition_id NUMBER, c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
893: SELECT 1
894: FROM ahl_prd_dispositions_b A
895: WHERE A.disposition_id = c_disposition_id
896: AND ((A.inventory_item_id = c_inventory_item_id
897: AND A.organization_id = c_organization_id)
898: OR EXISTS

Line 1070: FROM AHL_PRD_DISPOSITIONS_B disp, AHL_PRD_DISP_MTL_TXNS assoc,

1066: --
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)

Line 1110: FROM AHL_PRD_DISPOSITIONS_B disp, AHL_PRD_DISP_MTL_TXNS assoc,

1106: --
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