APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PART_CHANGES

Line 985: FROM ahl_part_changes

981: -- SATHAPLI::FP OGMA Issue# 86 - Automatic Material Return, 27-Dec-2007
982: -- Cursor to fetch the part change details.
983: CURSOR part_change_dtls_csr(p_part_change_id IN NUMBER) IS
984: SELECT removed_instance_id, part_change_type
985: FROM ahl_part_changes
986: WHERE part_change_id = p_part_change_id;
987:
988: -- Added by jaramana on 03-FEB-2011 for bug 10647408; sorao for Backporting project
989: -- Cursor to check whether removed instance is in job or not.

Line 1565: FROM ahl_part_changes

1561: -- SATHAPLI::FP OGMA Issue# 86 - Automatic Material Return, 27-Dec-2007
1562: -- Cursor to fetch the part change details.
1563: CURSOR part_change_dtls_csr(p_part_change_id IN NUMBER) IS
1564: SELECT removed_instance_id, part_change_type
1565: FROM ahl_part_changes
1566: WHERE part_change_id = p_part_change_id;
1567:
1568: l_exist VARCHAR(1);
1569:

Line 1590: FROM ahl_part_changes

1586:
1587: -- Cursor to get the removed instance id for a given part change id.
1588: CURSOR get_rem_inst_id_csr(c_part_change_id NUMBER) IS
1589: SELECT removed_instance_id
1590: FROM ahl_part_changes
1591: WHERE part_change_id = c_part_change_id;
1592: -- SATHAPLI::Bug 7111116, 21-May-2008, fix end
1593:
1594: -- Added by jaramana on 03-FEB-2011 for bug 10647408

Line 2607: FROM ahl_part_changes

2603:
2604: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
2605: CURSOR get_rem_inst_id_csr (p_part_change_id NUMBER) IS
2606: SELECT removed_instance_id
2607: FROM ahl_part_changes
2608: WHERE part_change_id = p_part_change_id;
2609:
2610: -- Cursor to check whether removed instance is in job or not.
2611: CURSOR chk_disp_inst_job_csr (p_instance_id NUMBER, p_workorder_id NUMBER) IS

Line 3346: FROM AHL_PART_CHANGES

3342: AND revision = p_revision;
3343:
3344: CURSOR part_change_csr(c_part_change_id IN NUMBER) IS
3345: SELECT REMOVED_INSTANCE_ID, INSTALLED_INSTANCE_ID, PART_CHANGE_TYPE
3346: FROM AHL_PART_CHANGES
3347: WHERE PART_CHANGE_ID = c_part_change_id;
3348:
3349: -- Added the following for fixing Bug#:4059944
3350: -- To find whether the Item is IB Trackable

Line 4499: FROM ahl_part_changes

4495:
4496: -- Begin Changes made by jaramana on August 07, 2007 for the bug 6328554 (FP of 5948917)
4497: CURSOR part_change_csr IS
4498: SELECT removed_instance_id, installed_instance_id, NVL(part_change_type, 'X'), quantity
4499: FROM ahl_part_changes
4500: WHERE part_change_id = p_part_change_id;
4501:
4502: -- Cursor to get the disposition instance details.
4503: CURSOR get_inst_dtls_csr(c_instance_id IN NUMBER) IS

Line 4623: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc

4619: SELECT disp.status_code, disp.trackable_flag,
4620: pc.return_mtl_txn_id mtl_txn_id,
4621: pc.installed_part_change_id install_pc_id,
4622: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4623: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc
4624: WHERE disp.disposition_id = p_disposition_id
4625: AND disp.part_change_id = pc.part_change_id (+);
4626: */
4627: -- AnRaj: Changed query, Perf Bug#4908609,Issue#5

Line 4635: AHL_PART_CHANGES_V pc

4631: pc.installed_part_change_id install_pc_id,
4632: pc.part_change_type,
4633: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4634: FROM AHL_PRD_DISPOSITIONS_B disp,
4635: AHL_PART_CHANGES_V pc
4636: WHERE disp.disposition_id = p_disposition_id
4637: AND disp.part_change_id = pc.part_change_id (+);
4638:
4639: --

Line 4649: FROM AHL_PART_CHANGES

4645: AND MTL.organization_id =p_inv_org_id;
4646: --
4647: CURSOR get_part_change_type_csr (p_part_change_id IN NUMBER) IS
4648: SELECT part_change_type
4649: FROM AHL_PART_CHANGES
4650: WHERE part_change_id = p_part_change_id;
4651: --
4652: CURSOR get_pos_mandatory_csr(p_instance_id IN NUMBER) IS
4653: SELECT rel.position_necessity_code