APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_VISITS_B

Line 1360: AHL_VISITS_B VST,

1356: SELECT
1357: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
1358: FROM
1359: AHL_WORKORDERS AWOS,
1360: AHL_VISITS_B VST,
1361: AHL_VISIT_TASKS_B VTS
1362: WHERE
1363: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
1364: VST.VISIT_ID = VTS.VISIT_ID AND

Line 3147: ahl_workorders wo, ahl_visits_b vst,

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

Line 4777: AHL_VISITS_B VST,

4773: SELECT
4774: NVL(VST.ITEM_INSTANCE_ID, VTS.INSTANCE_ID)
4775: FROM
4776: AHL_WORKORDERS AWOS,
4777: AHL_VISITS_B VST,
4778: AHL_VISIT_TASKS_B VTS
4779: WHERE
4780: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
4781: VST.VISIT_ID = VTS.VISIT_ID AND