APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_PRD_DISPOSITIONS_B

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

932: END IF;--end sr validation
933:
934: */
935:
936: /* Collection Id is now stored in AHL_PRD_DISPOSITIONS_B table */
937: /*
938: --************* QA plan *************--
939: -- Collection_id should not be null if subinventory status is MRB and a QA plan is attached to the item.
940:

Line 1202: /* Condition is stored in AHL_PRD_DISPOSITIONS_B

1198: CLOSE ahl_instance_id_csr;
1199: END IF;
1200: END IF;
1201:
1202: /* Condition is stored in AHL_PRD_DISPOSITIONS_B
1203: -- Get condition id if condition meaning is provided
1204: IF (p_x_parts_Rec.Condition is not null
1205: and p_x_parts_Rec.Condition_id is null) THEN
1206: -- dbms_output.put_line('inside ahl_condition_csr');

Line 3089: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,

3085: DISP.QUANTITY, DISP.UOM, disp.WO_OPERATION_ID, disp.item_revision revision,
3086: disp.serial_number, disp.lot_number,
3087: csi.inventory_item_id, vst.organization_id, vst.inv_locator_id,
3088: loc.subinventory_code, awo.operation_sequence_num
3089: FROM ahl_prd_dispositions_b disp, csi_item_instances csi,
3090: ahl_workorders wo, ahl_visits_b vst,
3091: mtl_item_locations_kfv loc, ahl_workorder_operations awo
3092: WHERE disp.instance_id = csi.instance_id
3093: AND disp.part_change_id = p_part_change_id