APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_PRD_DISPOSITIONS_B

Line 969: /* Collection Id is now stored in AHL_PRD_DISPOSITIONS_B table */

965: END IF;--end sr validation
966:
967: */
968:
969: /* Collection Id is now stored in AHL_PRD_DISPOSITIONS_B table */
970: /*
971: --************* QA plan *************--
972: -- Collection_id should not be null if subinventory status is MRB and a QA plan is attached to the item.
973:

Line 1235: /* Condition is stored in AHL_PRD_DISPOSITIONS_B

1231: CLOSE ahl_instance_id_csr;
1232: END IF;
1233: END IF;
1234:
1235: /* Condition is stored in AHL_PRD_DISPOSITIONS_B
1236: -- Get condition id if condition meaning is provided
1237: IF (p_x_parts_Rec.Condition is not null
1238: and p_x_parts_Rec.Condition_id is null) THEN
1239: -- dbms_output.put_line('inside ahl_condition_csr');

Line 3146: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,

3142: DISP.QUANTITY, DISP.UOM, disp.WO_OPERATION_ID, disp.item_revision revision,
3143: disp.serial_number, disp.lot_number,
3144: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3145: loc.subinventory_code, awo.operation_sequence_num
3146: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3147: ahl_workorders wo, ahl_visits_b vst,
3148: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3149: WHERE disp.instance_id = csi.instance_id
3150: AND disp.part_change_id = p_part_change_id