APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PART_CHANGES

Line 982: FROM ahl_part_changes

978: -- SATHAPLI::FP OGMA Issue# 86 - Automatic Material Return, 27-Dec-2007
979: -- Cursor to fetch the part change details.
980: CURSOR part_change_dtls_csr(p_part_change_id IN NUMBER) IS
981: SELECT removed_instance_id, part_change_type
982: FROM ahl_part_changes
983: WHERE part_change_id = p_part_change_id;
984:
985: l_disposition_h_id NUMBER;
986: l_dummy_char VARCHAR(30);

Line 1405: FROM ahl_part_changes

1401: -- SATHAPLI::FP OGMA Issue# 86 - Automatic Material Return, 27-Dec-2007
1402: -- Cursor to fetch the part change details.
1403: CURSOR part_change_dtls_csr(p_part_change_id IN NUMBER) IS
1404: SELECT removed_instance_id, part_change_type
1405: FROM ahl_part_changes
1406: WHERE part_change_id = p_part_change_id;
1407:
1408: l_exist VARCHAR(1);
1409:

Line 1430: FROM ahl_part_changes

1426:
1427: -- Cursor to get the removed instance id for a given part change id.
1428: CURSOR get_rem_inst_id_csr(c_part_change_id NUMBER) IS
1429: SELECT removed_instance_id
1430: FROM ahl_part_changes
1431: WHERE part_change_id = c_part_change_id;
1432: -- SATHAPLI::Bug 7111116, 21-May-2008, fix end
1433:
1434: l_disposition_rec disposition_csr%ROWTYPE;

Line 2305: FROM ahl_part_changes

2301:
2302: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 13-Dec-2007
2303: CURSOR get_rem_inst_id_csr (p_part_change_id NUMBER) IS
2304: SELECT removed_instance_id
2305: FROM ahl_part_changes
2306: WHERE part_change_id = p_part_change_id;
2307:
2308: -- Cursor to check whether removed instance is in job or not.
2309: CURSOR chk_disp_inst_job_csr (p_instance_id NUMBER, p_workorder_id NUMBER) IS

Line 2923: FROM AHL_PART_CHANGES

2919: AND revision = p_revision;
2920:
2921: CURSOR part_change_csr(c_part_change_id IN NUMBER) IS
2922: SELECT REMOVED_INSTANCE_ID, INSTALLED_INSTANCE_ID, PART_CHANGE_TYPE
2923: FROM AHL_PART_CHANGES
2924: WHERE PART_CHANGE_ID = c_part_change_id;
2925:
2926: -- Added the following for fixing Bug#:4059944
2927: -- To find whether the Item is IB Trackable

Line 4039: FROM ahl_part_changes

4035:
4036: -- Begin Changes made by jaramana on August 07, 2007 for the bug 6328554 (FP of 5948917)
4037: CURSOR part_change_csr IS
4038: SELECT removed_instance_id, installed_instance_id, NVL(part_change_type, 'X'), quantity
4039: FROM ahl_part_changes
4040: WHERE part_change_id = p_part_change_id;
4041:
4042: -- Cursor to get the disposition instance details.
4043: CURSOR get_inst_dtls_csr(c_instance_id IN NUMBER) IS

Line 4163: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc

4159: SELECT disp.status_code, disp.trackable_flag,
4160: pc.return_mtl_txn_id mtl_txn_id,
4161: pc.installed_part_change_id install_pc_id,
4162: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4163: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_PART_CHANGES_V pc
4164: WHERE disp.disposition_id = p_disposition_id
4165: AND disp.part_change_id = pc.part_change_id (+);
4166: */
4167: -- AnRaj: Changed query, Perf Bug#4908609,Issue#5

Line 4175: AHL_PART_CHANGES_V pc

4171: pc.installed_part_change_id install_pc_id,
4172: pc.part_change_type,
4173: AHL_PRD_DISP_MTL_TXN_PVT.calculate_txned_qty(disp.disposition_id) mtl_txn_qty
4174: FROM AHL_PRD_DISPOSITIONS_B disp,
4175: AHL_PART_CHANGES_V pc
4176: WHERE disp.disposition_id = p_disposition_id
4177: AND disp.part_change_id = pc.part_change_id (+);
4178:
4179: --

Line 4189: FROM AHL_PART_CHANGES

4185: AND MTL.organization_id =p_inv_org_id;
4186: --
4187: CURSOR get_part_change_type_csr (p_part_change_id IN NUMBER) IS
4188: SELECT part_change_type
4189: FROM AHL_PART_CHANGES
4190: WHERE part_change_id = p_part_change_id;
4191: --
4192: CURSOR get_pos_mandatory_csr(p_instance_id IN NUMBER) IS
4193: SELECT rel.position_necessity_code