WIP Job Upload

➜ Back to Library
Description

WIP Job Upload creates and updates Oracle Work in Process discrete jobs – Standard and Non-Standard – including job headers, operations, resources and material requirements (components), across one or more inventory organizations, from Excel. It loads the WIP Mass Load interface and runs the standard WIP Mass Load program (one run per organization).

When to use it

  • Mass-create new discrete jobs (Standard or Non-Standard) instead of keying them one by one.
  • Bulk-update existing job headers – status, quantities, dates, scheduling, class, completion subinventory/locator, schedule group, line, project/task, flexfields.
  • Add or change job operations, resources and components in bulk, including on existing jobs.
  • Load jobs across several inventory organizations in one file.
  • Seed or migrate jobs during an implementation or data load.

Before you start

  • Blitz Report is installed and you are signed in to a WIP-enabled responsibility with access to the organization.
  • For Standard jobs, the assembly item exists in the organization (and has a routing/BOM where you want it scheduled or exploded).
  • A valid WIP accounting class exists for the job type; referenced departments, operations, resources, subinventories and locators exist in the org.
  • The WIP accounting period for the job dates is open.

Choose a template

TemplateUse it for
DefaultThe full template – job header plus operation, resource and component detail rows.
Job HeadersCreate or update job headers only – a lighter file with no operation/resource/component columns.

Pick the template that matches the work; this upload has no pre-set site default, so choose one when you download.

Step 1 – Choose a template and mode, set the parameters and download

In Blitz Report, open WIP Job Upload, choose your template, and set the parameters:

ParameterPurpose
Upload ModeCreate (empty template for new jobs) or Create, Update (download existing jobs to edit). Default is Create.
Auto Generate Job NameYes (default) lets the system name new jobs; No lets you name them manually.
Organization CodeThe inventory organization (defaults to your manufacturing org).
Job / Job From / Job To / Job Status / Type / Assembly / dates / Schedule Group / Line / Project / TaskFilters that restrict which existing jobs are downloaded.

Run the upload to download and open the Excel file. Each job is automatically handled as a create or an update depending on whether it already exists in the organization.

Step 2 – Enter the jobs

Each spreadsheet row is one item; the Upload Job Identifier groups a job’s header and detail rows. On the header row enter the Organization Code, Type (Standard/Non-Standard), Assembly, Class, Job Status, Start Quantity and the scheduling dates. For jobs with a routing supply one of Scheduled Start Date or Scheduled Completion Date; for jobs without a routing supply both. Add rows for Operations, Resources and Components as needed.

Step 3 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.

Step 4 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which loads the WIP Mass Load interface and runs WIP Mass Load (one run per organization). When it finishes, a result report opens showing each row as success or error.

What’s produced

  • Created and updated discrete jobs with their operations, resources and components.
  • A result report listing every row with a status (success or error) and a message; auto-generated job names are written back.

Common questions

Does it create both Standard and Non-Standard jobs?
Yes – the Type column selects Standard or Non-Standard.

How does it know whether to create or update?
It looks the job up by name/identifier in the selected organization – not found = create, found = update. There is no per-row action switch.

Can it delete jobs, operations or components?
No. The upload only creates and updates.

What dates do I need?
For a job with a routing, supply just the start date (forward-schedules) or the completion date (backward-schedules). For a job without a routing, supply both.

When is the BOM/routing exploded?
By default only for new header-only jobs. If you include operation/component rows, they are kept and the BOM/routing is not auto-exploded; updates are never auto-re-exploded.

My Non-Standard job won’t update – why?
A Non-Standard job with no assembly and no routing reference cannot be updated through WIP Mass Load; edit it in the Discrete Jobs form.

Troubleshooting

MessageCauseWhat to do
Non-standard jobs without an assembly or routing reference cannot be updated via WIP Mass LoadUpdating a Non-Standard job that has neither an assembly nor a routing reference.Edit that job directly in the Discrete Jobs form.
A scheduled start or completion date is required for jobs with a routingA routed job was entered with both date columns blank.Supply the start date (forward-schedule) or the completion date (backward-schedule).
Both scheduled start and completion dates are required for jobs without a routingA non-routed job is missing one of the two dates.Enter both dates.
Resource is not assigned to the operation’s departmentThe resource on a resource row isn’t assigned to that operation’s department.Fix the department’s resource assignment, or use a resource valid for that department.
One or more rows for this job are in errorA validation error on any row of a job cascades to the whole job (a job is processed in full or not at all).Read the per-row Message in the result, fix the offending rows, and re-upload the job.
select
null action_,
null status_,
null message_,
null request_id_,
null modified_columns_,
to_char(null) job_rowid,
to_char(null) operation_rowid,
to_char(null) resource_rowid,
to_char(null) component_rowid,
to_char(null) auto_generate_job_name,
x.*
from
(
-- branch 1: operations + resources (outer joined, also returns header-only jobs)
select
-- Job
mp.organization_code,
we.wip_entity_name upload_job_identifier,
we.wip_entity_name job_name,
xxen_util.meaning(wdj.job_type,'WIP_DISCRETE_JOB',700) job_type,
wdj.description job_description,
(select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id=wdj.primary_item_id and msiv.organization_id=wdj.organization_id) assembly,
(select msiv0.description from mtl_system_items_vl msiv0 where msiv0.inventory_item_id=wdj.primary_item_id and msiv0.organization_id=wdj.organization_id) assembly_description,
wdj.class_code,
xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) job_status,
xxen_util.meaning(wdj.firm_planned_flag,'SYS_YES_NO',700) firm,
wdj.start_quantity,
wdj.net_quantity mrp_net_quantity,
wdj.scheduled_start_date,
wdj.scheduled_completion_date,
wdj.start_quantity-wdj.quantity_completed-wdj.quantity_scrapped quantity_remaining,
wdj.quantity_completed,
wdj.quantity_scrapped,
wdj.date_released,
wdj.date_completed,
wdj.date_closed,
(select msiv2.concatenated_segments from mtl_system_items_vl msiv2 where msiv2.inventory_item_id=wdj.bom_reference_id and msiv2.organization_id=wdj.organization_id) bom_reference,
(select msiv2b.description from mtl_system_items_vl msiv2b where msiv2b.inventory_item_id=wdj.bom_reference_id and msiv2b.organization_id=wdj.organization_id) bom_reference_description,
wdj.alternate_bom_designator bom_alternate_designator,
wdj.bom_revision,
wdj.bom_revision_date,
xxen_util.meaning(wdj.wip_supply_type,'WIP_SUPPLY',700) supply_type,
(select msiv3.concatenated_segments from mtl_system_items_vl msiv3 where msiv3.inventory_item_id=wdj.routing_reference_id and msiv3.organization_id=wdj.organization_id) routing_reference,
(select msiv3b.description from mtl_system_items_vl msiv3b where msiv3b.inventory_item_id=wdj.routing_reference_id and msiv3b.organization_id=wdj.organization_id) routing_reference_description,
wdj.alternate_routing_designator routing_alternate_designator,
wdj.serialization_start_op,
wdj.routing_revision,
wdj.routing_revision_date,
wdj.completion_subinventory,
(select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id=wdj.completion_locator_id) completion_locator,
(select wsg.schedule_group_name from wip_schedule_groups wsg where wsg.schedule_group_id=wdj.schedule_group_id) schedule_group,
wdj.build_sequence,
(select wl.line_code from wip_lines wl where wl.line_id=wdj.line_id and wl.organization_id=wdj.organization_id) line,
(select ppmv.project_number from pjm_projects_mtll_v ppmv where ppmv.project_id=wdj.project_id) project,
(select pt.task_number from pa_tasks pt where pt.task_id=wdj.task_id) task,
wdj.end_item_unit_number,
wdj.requested_start_date,
wdj.due_date requested_due_date,
wdj.priority scheduling_priority,
wdj.due_date_penalty,
wdj.due_date_tolerance,
wdj.demand_class,
wdj.lot_number,
xxen_util.meaning(wdj.overcompletion_tolerance_type,'WIP_TOLERANCE_TYPE',700) overcompletion_tolerance_type,
wdj.overcompletion_tolerance_value,
to_char(null) explode_bom_and_routing,
wdj.source_code,
wdj.source_line_id,
xxen_util.display_flexfield_context(706,'WIP_DISCRETE_JOBS',wdj.attribute_category) job_attribute_category,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE1',wdj.rowid,wdj.attribute1) job_attribute1,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE2',wdj.rowid,wdj.attribute2) job_attribute2,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE3',wdj.rowid,wdj.attribute3) job_attribute3,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE4',wdj.rowid,wdj.attribute4) job_attribute4,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE5',wdj.rowid,wdj.attribute5) job_attribute5,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE6',wdj.rowid,wdj.attribute6) job_attribute6,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE7',wdj.rowid,wdj.attribute7) job_attribute7,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE8',wdj.rowid,wdj.attribute8) job_attribute8,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE9',wdj.rowid,wdj.attribute9) job_attribute9,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE10',wdj.rowid,wdj.attribute10) job_attribute10,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE11',wdj.rowid,wdj.attribute11) job_attribute11,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE12',wdj.rowid,wdj.attribute12) job_attribute12,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE13',wdj.rowid,wdj.attribute13) job_attribute13,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE14',wdj.rowid,wdj.attribute14) job_attribute14,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE15',wdj.rowid,wdj.attribute15) job_attribute15,
-- Operations
wo.operation_seq_num,
(select bso.operation_code from bom_standard_operations bso where bso.standard_operation_id=wo.standard_operation_id and bso.organization_id=wo.organization_id) operation_code,
(select bd.department_code from bom_departments bd where bd.department_id=wo.department_id) department,
xxen_util.meaning(wo.count_point_type,'BOM_COUNT_POINT_TYPE',700) count_point,
xxen_util.meaning(wor.autocharge_type,'BOM_AUTOCHARGE_TYPE',700) autocharge,
xxen_util.meaning(wo.backflush_flag,'SYS_YES_NO',700) backflush,
wo.minimum_transfer_quantity,
wo.first_unit_start_date,
wo.first_unit_completion_date,
wo.last_unit_start_date,
wo.last_unit_completion_date,
wo.description operation_description,
-- Resource
wor.resource_seq_num,
(select br.resource_code from bom_resources br where br.resource_id=wor.resource_id and br.organization_id=wor.organization_id) resource_sub_element,
wor.uom_code resource_uom,
xxen_util.meaning(wor.basis_type,'CST_BASIS',700) resource_basis,
wor.usage_rate_or_amount,
wor.assigned_units,
xxen_util.meaning(wor.scheduled_flag,'BOM_RESOURCE_SCHEDULE_TYPE',700) scheduled,
wor.schedule_seq_num,
(select ca.activity from cst_activities ca where ca.activity_id=wor.activity_id) activity,
wor.start_date resource_start_date,
wor.completion_date resource_completion_date,
-- Component
to_char(null) component,
to_char(null) component_description,
to_char(null) component_uom,
to_number(null) component_operation_seq_num,
to_char(null) component_department,
to_date(null) component_date_required,
to_char(null) component_basis,
to_number(null) component_quantity_per_assembly,
to_number(null) component_required_quantity,
to_number(null) component_yield_factor,
to_char(null) component_supply_type,
to_char(null) component_supply_subinventory,
to_char(null) component_supply_locator,
to_char(null) component_mrp_net,
-- Ids
wdj.wip_entity_id,
wdj.organization_id,
to_number(null) component_item_id,
nvl2(wo.operation_seq_num,1,2) row_type_sort,
to_number(null) upload_row
from
mtl_parameters mp,
wip_discrete_jobs wdj,
wip_entities we,
wip_operations wo,
wip_operation_resources wor
where
mp.organization_code in (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
mp.organization_id=wdj.organization_id and
we.entity_type not in (5,6,7,8,9,10) and
wdj.status_type in (1,3,4,6,7) and
wdj.wip_entity_id=we.wip_entity_id and
wdj.organization_id=we.organization_id and
case when :p_download_operations='Y' then wdj.wip_entity_id end=wo.wip_entity_id(+) and
case when :p_download_operations='Y' then wdj.organization_id end=wo.organization_id(+) and
wo.wip_entity_id=wor.wip_entity_id(+) and
wo.operation_seq_num=wor.operation_seq_num(+) and
wo.organization_id=wor.organization_id(+) and
1=1 and
2=2
union all
-- branch 2: components
select
-- Job
mp.organization_code,
we.wip_entity_name upload_job_identifier,
we.wip_entity_name job_name,
xxen_util.meaning(wdj.job_type,'WIP_DISCRETE_JOB',700) job_type,
wdj.description job_description,
(select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id=wdj.primary_item_id and msiv.organization_id=wdj.organization_id) assembly,
(select msiv0.description from mtl_system_items_vl msiv0 where msiv0.inventory_item_id=wdj.primary_item_id and msiv0.organization_id=wdj.organization_id) assembly_description,
wdj.class_code,
xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) job_status,
xxen_util.meaning(wdj.firm_planned_flag,'SYS_YES_NO',700) firm,
wdj.start_quantity,
wdj.net_quantity mrp_net_quantity,
wdj.scheduled_start_date,
wdj.scheduled_completion_date,
wdj.start_quantity-wdj.quantity_completed-wdj.quantity_scrapped quantity_remaining,
wdj.quantity_completed,
wdj.quantity_scrapped,
wdj.date_released,
wdj.date_completed,
wdj.date_closed,
(select msiv2.concatenated_segments from mtl_system_items_vl msiv2 where msiv2.inventory_item_id=wdj.bom_reference_id and msiv2.organization_id=wdj.organization_id) bom_reference,
(select msiv2b.description from mtl_system_items_vl msiv2b where msiv2b.inventory_item_id=wdj.bom_reference_id and msiv2b.organization_id=wdj.organization_id) bom_reference_description,
wdj.alternate_bom_designator bom_alternate_designator,
wdj.bom_revision,
wdj.bom_revision_date,
xxen_util.meaning(wdj.wip_supply_type,'WIP_SUPPLY',700) supply_type,
(select msiv3.concatenated_segments from mtl_system_items_vl msiv3 where msiv3.inventory_item_id=wdj.routing_reference_id and msiv3.organization_id=wdj.organization_id) routing_reference,
(select msiv3b.description from mtl_system_items_vl msiv3b where msiv3b.inventory_item_id=wdj.routing_reference_id and msiv3b.organization_id=wdj.organization_id) routing_reference_description,
wdj.alternate_routing_designator routing_alternate_designator,
wdj.serialization_start_op,
wdj.routing_revision,
wdj.routing_revision_date,
wdj.completion_subinventory,
(select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id=wdj.completion_locator_id) completion_locator,
(select wsg.schedule_group_name from wip_schedule_groups wsg where wsg.schedule_group_id=wdj.schedule_group_id) schedule_group,
wdj.build_sequence,
(select wl.line_code from wip_lines wl where wl.line_id=wdj.line_id and wl.organization_id=wdj.organization_id) line,
(select ppmv.project_number from pjm_projects_mtll_v ppmv where ppmv.project_id=wdj.project_id) project,
(select pt.task_number from pa_tasks pt where pt.task_id=wdj.task_id) task,
wdj.end_item_unit_number,
wdj.requested_start_date,
wdj.due_date requested_due_date,
wdj.priority scheduling_priority,
wdj.due_date_penalty,
wdj.due_date_tolerance,
wdj.demand_class,
wdj.lot_number,
xxen_util.meaning(wdj.overcompletion_tolerance_type,'WIP_TOLERANCE_TYPE',700) overcompletion_tolerance_type,
wdj.overcompletion_tolerance_value,
to_char(null) explode_bom_and_routing,
wdj.source_code,
wdj.source_line_id,
xxen_util.display_flexfield_context(706,'WIP_DISCRETE_JOBS',wdj.attribute_category) job_attribute_category,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE1',wdj.rowid,wdj.attribute1) job_attribute1,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE2',wdj.rowid,wdj.attribute2) job_attribute2,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE3',wdj.rowid,wdj.attribute3) job_attribute3,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE4',wdj.rowid,wdj.attribute4) job_attribute4,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE5',wdj.rowid,wdj.attribute5) job_attribute5,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE6',wdj.rowid,wdj.attribute6) job_attribute6,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE7',wdj.rowid,wdj.attribute7) job_attribute7,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE8',wdj.rowid,wdj.attribute8) job_attribute8,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE9',wdj.rowid,wdj.attribute9) job_attribute9,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE10',wdj.rowid,wdj.attribute10) job_attribute10,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE11',wdj.rowid,wdj.attribute11) job_attribute11,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE12',wdj.rowid,wdj.attribute12) job_attribute12,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE13',wdj.rowid,wdj.attribute13) job_attribute13,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE14',wdj.rowid,wdj.attribute14) job_attribute14,
xxen_util.display_flexfield_value(706,'WIP_DISCRETE_JOBS',wdj.attribute_category,'ATTRIBUTE15',wdj.rowid,wdj.attribute15) job_attribute15,
-- Operation
to_number(null) operation_seq_num,
to_char(null) operation_code,
to_char(null) department,
to_char(null) count_point,
to_char(null) autocharge,
to_char(null) backflush,
to_number(null) minimum_transfer_quantity,
to_date(null) first_unit_start_date,
to_date(null) first_unit_completion_date,
to_date(null) last_unit_start_date,
to_date(null) last_unit_completion_date,
to_char(null) operation_description,
-- Resource
to_number(null) resource_seq_num,
to_char(null) resource_sub_element,
to_char(null) resource_uom,
to_char(null) resource_basis,
to_number(null) usage_rate_or_amount,
to_number(null) assigned_units,
to_char(null) scheduled,
to_number(null) schedule_seq_num,
to_char(null) activity,
to_date(null) resource_start_date,
to_date(null) resource_completion_date,
-- Component
(select msiv4.concatenated_segments from mtl_system_items_vl msiv4 where msiv4.inventory_item_id=wro.inventory_item_id and msiv4.organization_id=wro.organization_id) component,
(select msiv4b.description from mtl_system_items_vl msiv4b where msiv4b.inventory_item_id=wro.inventory_item_id and msiv4b.organization_id=wro.organization_id) component_description,
(select msiv4c.primary_uom_code from mtl_system_items_vl msiv4c where msiv4c.inventory_item_id=wro.inventory_item_id and msiv4c.organization_id=wro.organization_id) component_uom,
wro.operation_seq_num component_operation_seq_num,
(select bd.department_code from bom_departments bd where bd.department_id=wro.department_id) component_department,
wro.date_required component_date_required,
xxen_util.meaning(wro.basis_type,'CST_BASIS',700) component_basis,
wro.quantity_per_assembly component_quantity_per_assembly,
wro.required_quantity component_required_quantity,
wro.component_yield_factor,
xxen_util.meaning(wro.wip_supply_type,'WIP_SUPPLY',700) component_supply_type,
wro.supply_subinventory component_supply_subinventory,
(select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id=wro.supply_locator_id) component_supply_locator,
xxen_util.meaning(wro.mrp_net_flag,'SYS_YES_NO',700) component_mrp_net,
-- Ids
wdj.wip_entity_id,
wdj.organization_id,
wro.inventory_item_id component_item_id,
2 row_type_sort,
to_number(null) upload_row
from
mtl_parameters mp,
wip_discrete_jobs wdj,
wip_entities we,
wip_requirement_operations wro
where
mp.organization_code in (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
mp.organization_id=wdj.organization_id and
we.entity_type not in (5,6,7,8,9,10) and
wdj.status_type in (1,3,4,6,7) and
wdj.wip_entity_id=we.wip_entity_id and
wdj.organization_id=we.organization_id and
wdj.wip_entity_id=wro.wip_entity_id and
wdj.organization_id=wro.organization_id and
wro.wip_supply_type<>6 and
wro.operation_seq_num>0 and
:p_download_components='Y' and
1=1 and
2=2
) x
Parameter NameSQL textValidation
Upload Mode
:p_upload_mode like '%' || xxen_upload.action_update
LOV
Auto Generate Job Name
 
LOV Oracle
Download Operations
 
LOV
Download Components
 
LOV
Organization Code
mp.organization_code=:p_organization_code
LOV
Job
we.wip_entity_name=:p_job
LOV
Job From
we.wip_entity_name>=:p_job_from
LOV
Job To
we.wip_entity_name<=:p_job_to
LOV
Job Status
wdj.status_type=:p_job_status
LOV
Type
wdj.job_type=:p_job_type
LOV
Assembly
wdj.primary_item_id=:p_assembly
LOV
Schedule Group
wdj.schedule_group_id=:p_schedule_group
LOV
Build Sequence From
wdj.build_sequence>=:p_build_seq_from
Char
Build Sequence To
wdj.build_sequence<=:p_build_seq_to
Char
Class
wdj.class_code=:p_class_code
LOV
Start Date From
wdj.scheduled_start_date>=:p_start_date_from
Char
Start Date To
wdj.scheduled_start_date<:p_start_date_to+1
Char
Completion Date From
wdj.scheduled_completion_date>=:p_completion_date_from
Char
Completion Date To
wdj.scheduled_completion_date<:p_completion_date_to+1
Char
Line
wdj.line_id=:p_line
LOV
Project Number
wdj.project_id=:p_project
LOV
Task Number
wdj.task_id=:p_task
LOV
Download
Related Blitz Reports
AR Transactions and Lines Ashish test upload 1410252 WSH Commercial Invoice PO Vendor Service Performance Analysis WIP Required Components ECC Discrete Manufacturing, Components ONT Order Discount Detail APL: AR Transactions and Lines ECC Procurement, Purchase Orders CAC Inventory Lot and Locator OPM Value (Period-End)
Blitz Report™