APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_VISITS_B

Line 1327: AHL_VISITS_B VST,

1323: SELECT
1324: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
1325: FROM
1326: AHL_WORKORDERS AWOS,
1327: AHL_VISITS_B VST,
1328: AHL_VISIT_TASKS_B VTS
1329: WHERE
1330: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
1331: VST.VISIT_ID = VTS.VISIT_ID AND

Line 3090: ahl_workorders wo, ahl_visits_b vst,

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
3094: AND disp.workorder_id = wo.workorder_id

Line 4720: AHL_VISITS_B VST,

4716: SELECT
4717: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
4718: FROM
4719: AHL_WORKORDERS AWOS,
4720: AHL_VISITS_B VST,
4721: AHL_VISIT_TASKS_B VTS
4722: WHERE
4723: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
4724: VST.VISIT_ID = VTS.VISIT_ID AND