DBA Data[Home] [Help]

APPS.WIP_WPS_RES_INSTANCE_AVAIL dependencies on BOM_RES_INSTANCE_CHANGES

Line 156: bom_res_instance_changes changes,

152: dates.shift_date,
153: changes.shift_num,
154: reschanges.capacity_change
155: from bom_shift_dates dates,
156: bom_res_instance_changes changes,
157: bom_resource_changes reschanges,
158: mtl_parameters param
159: WHERE dates.calendar_code = param.calendar_code
160: AND dates.exception_set_id = param.calendar_exception_set_id

Line 522: FROM bom_res_instance_changes changes

518: sysdate,
519: var_gt_user_id,
520: sysdate,
521: var_gt_user_id
522: FROM bom_res_instance_changes changes
523: WHERE changes.department_id = arg_department_id
524: AND changes.resource_id = arg_resource_id
525: and changes.instance_id = arg_instance_id
526: and nvl(changes.serial_number,-1) = nvl(arg_serial_num, -1)