ENGINATICSSYSTEM_ADMINISTRATORSYSADMINE811F942597A2075E0530100007FF4F2Blitz Upload ModeYselect xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual
US8E2FF36EDEB279D2E0530100007F1FF2INV Organization CodeYselect
ood.organization_code value,
ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description
from
org_organization_definitions ood,
mtl_parameters mp,
mtl_parameters mp0,
hr_all_organization_units haou,
hr_locations_all hla,
fnd_territories_vl ftv
where
ood.organization_id=mp.organization_id and
mp.organization_id<>mp.master_organization_id and
(
ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or
not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)
) and
(:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and
(:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and
nvl(ood.disable_date,sysdate)>=sysdate and
mp.master_organization_id=mp0.organization_id and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+)
order by
ood.organization_codeARجميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحاليDAlle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen BenutzersETodos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actualFTous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuelITutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente correnteJAすべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。KO현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드PTBTodos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atualRUВсе активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре.SAlla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvyTRAna organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdırUSAll active inventory organization codes excluding master organizations, restricted to the current user's org access viewZHS所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。8E2FF36EDEA679D2E0530100007F1FF2YesYselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUS4FAC39A5CFF23DB2E0630100007F99D8select
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
) xYUAxxen_wip_upload.create_update_jobxxen_wip_upload.post_wip_mass_loadUSWIP Job UploadUpload to create and update WIP Discrete Jobs (Standard and Non-Standard) including operations, resources, and material requirements (components). Multiple inventory organizations can be combined in one upload file; the upload submits a separate WIP Mass Load run per organization.
Job headers support all standard fields including assembly, class code, status, quantities, dates, scheduling, BOM/routing references (non-standard jobs), completion subinventory/locator, schedule group, line, project/task, and descriptive flexfield attributes.
Operations, resources, and material requirements (components) can be added on new and existing jobs and modified on existing jobs. A single upload row can carry header, operation/resource, and component fields simultaneously, so compact entry does not require separate row types.
Explode Bom and Routing. By default, Bom and Routing are automatically exploded only for new jobs (create) where the job does not have detail entries (operations/resources/components) included in the upload. This is to preserve the manually entered details on upload. If uploading Job Details for a new job, then all the detail entries for the Job should be included in the upload. The Bom and Routing are not automatically re-exploded when updating an existing job. There is a hidden ‘Explode Bom and Routing’ column in the upload that can be used to override this default behaviour.
Scheduled Start and Completion Dates. For jobs with a routing (the assembly’s own routing for Standard jobs, or a Routing Reference for Non-Standard jobs), supply one of Scheduled Start Date or Scheduled Completion Date — providing the start forward-schedules, providing the completion backward-schedules. The system computes the other end from the routing lead times. If both are supplied, forward-scheduling from the start is used. For jobs without a routing, both dates are required and are stored verbatim. The same rules apply on update: changing only the start triggers a forward reschedule, changing only the completion triggers a backward reschedule.
Job creation supports both automatic job name generation (via the WIP Job Prefix profile and sequence) and manual job naming. The Upload Job Identifier column uniquely identifies a job in the upload and provides traceability between uploaded rows and the eventual job name when automatic naming is used. It must be unique per logical job within a single upload. For manual job naming, the Upload Job Identifier will also be used as the Job Name if a Job Name is not specifically entered in the upload.
Non-standard jobs without an assembly or routing reference cannot be updated through WIP Mass Load; such jobs must be edited in the Discrete Jobs form directly. The upload reports a clear error if attempted.
Processing uses the WIP Mass Load interface (wip_job_schedule_interface and wip_job_dtls_interface) with the WICMLP concurrent program. Validation errors are detected per job and cascaded to all rows of the affected job so the job is either processed in its entirety or not at all.
EnginaticsUpload1=1:p_download_components:p_download_operations1101=1:p_upload_mode like '%' || xxen_upload.action_updateLOVBlitz Upload ModeE811F942597A2075E0530100007FF4F2Yselect xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual
CYUSUpload Mode211:p_auto_generate_job_nameLOV OracleYes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionYYUSAuto Generate Job Name312:p_download_operationsLOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSDownload Operations414:p_download_componentsLOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSDownload Components5151=1mp.organization_code=:p_organization_codeLOVINV Organization Code8E2FF36EDEB279D2E0530100007F1FF2Yselect
ood.organization_code value,
ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description
from
org_organization_definitions ood,
mtl_parameters mp,
mtl_parameters mp0,
hr_all_organization_units haou,
hr_locations_all hla,
fnd_territories_vl ftv
where
ood.organization_id=mp.organization_id and
mp.organization_id<>mp.master_organization_id and
(
ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or
not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)
) and
(:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and
(:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and
nvl(ood.disable_date,sysdate)>=sysdate and
mp.master_organization_id=mp0.organization_id and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+)
order by
ood.organization_codeselect mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')USOrganization Code6201=1we.wip_entity_name=:p_jobLOV customYYselect
we.wip_entity_name value,
null description
from
wip_entities we
where
we.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code) and
we.entity_type not in (5,6,7,8,9,10)
order by 1USJob7301=1we.wip_entity_name>=:p_job_fromLOV customYYselect
we.wip_entity_name value,
null description
from
wip_entities we
where
we.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code) and
we.entity_type not in (5,6,7,8,9,10)
order by 1USJob From8401=1we.wip_entity_name<=:p_job_toLOV customYYselect
we.wip_entity_name value,
null description
from
wip_entities we
where
we.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code) and
we.entity_type not in (5,6,7,8,9,10)
order by 1USJob To9451=1wdj.status_type=:p_job_statusLOV customYselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='WIP_JOB_STATUS' and ml.lookup_code in (1,3,4,6,7) order by 1USJob Status10501=1wdj.job_type=:p_job_typeLOV customYselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='WIP_DISCRETE_JOB' order by 1USType11601=1wdj.primary_item_id=:p_assemblyLOV customYYselect
msiv.inventory_item_id id,
msiv.concatenated_segments value,
msiv.description
from
mtl_system_items_vl msiv
where
msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code) and
msiv.bom_item_type in (1,2,4) and
msiv.pick_components_flag='N'
order by 1USAssembly12701=1wdj.schedule_group_id=:p_schedule_groupLOV customYselect
wsg.schedule_group_id id,
wsg.schedule_group_name value,
wsg.description
from
wip_schedule_groups wsg
where
wsg.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code) and
nvl(wsg.inactive_on,sysdate+1)>sysdate
order by 1USSchedule Group13801=1wdj.build_sequence>=:p_build_seq_fromCharUSBuild Sequence From14901=1wdj.build_sequence<=:p_build_seq_toCharUSBuild Sequence To151001=1wdj.class_code=:p_class_codeLOV customYselect
wdcav.class_code value,
wdcav.description
from
wip_discrete_classes_all_v wdcav
where
wdcav.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code) and
wdcav.class_type in (1,3,4)
order by 1USClass161101=1wdj.scheduled_start_date>=:p_start_date_fromCharUSStart Date From171201=1wdj.scheduled_start_date<:p_start_date_to+1CharUSStart Date To181301=1wdj.scheduled_completion_date>=:p_completion_date_fromCharUSCompletion Date From191401=1wdj.scheduled_completion_date<:p_completion_date_to+1CharUSCompletion Date To201501=1wdj.line_id=:p_lineLOV customYselect
wl.line_id id,
wl.line_code value,
wl.description
from
wip_lines wl
where
wl.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code)
order by 1USLine211601=1wdj.project_id=:p_projectLOV customYYselect
ppv.project_id id,
ppv.project_number value,
ppv.project_name description
from
pjm_projects_v ppv,
pjm_project_parameters ppp
where
ppp.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code) and
ppv.project_id=ppp.project_id
order by ppv.project_numberUSProject Number221701=1wdj.task_id=:p_taskLOV customYYselect
pt.task_id id,
pt.task_number value,
pt.task_name description
from
pa_tasks pt
where
pt.project_id=:$flex$.Project_Number
order by 1USTask Number:$flex$.Organization_CodeOrganization CodeAssembly:$flex$.Organization_CodeOrganization CodeClass:$flex$.Organization_CodeOrganization CodeJob:$flex$.Organization_CodeOrganization CodeJob From:$flex$.Organization_CodeOrganization CodeJob To:$flex$.Organization_CodeOrganization CodeLine:$flex$.Organization_CodeOrganization CodeProject Number:$flex$.Organization_CodeOrganization CodeSchedule Group:$flex$.Project_NumberProject NumberTask NumberDefaultERIC.CLEGG64ACTIVITY6ASSEMBLY7ASSEMBLY_DESCRIPTION61ASSIGNED_UNITS48AUTOCHARGE49BACKFLUSH17BOM_ALTERNATE_DESIGNATOR15BOM_REFERENCE16BOM_REFERENCE_DESCRIPTION18BOM_REVISION19BOM_REVISION_DATE30BUILD_SEQUENCE8CLASS_CODE28COMPLETION_LOCATOR27COMPLETION_SUBINVENTORY67COMPONENT73COMPONENT_BASIS72COMPONENT_DATE_REQUIRED71COMPONENT_DEPARTMENT68COMPONENT_DESCRIPTION80COMPONENT_MRP_NET70COMPONENT_OPERATION_SEQ_NUM74COMPONENT_QUANTITY_PER_ASSEMBLY75COMPONENT_REQUIRED_QUANTITY79COMPONENT_SUPPLY_LOCATOR78COMPONENT_SUPPLY_SUBINVENTORY77COMPONENT_SUPPLY_TYPE69COMPONENT_UOM76COMPONENT_YIELD_FACTOR47COUNT_POINT40DEMAND_CLASS46DEPARTMENT38DUE_DATE_PENALTY39DUE_DATE_TOLERANCE34END_ITEM_UNIT_NUMBER10FIRM52FIRST_UNIT_COMPLETION_DATE51FIRST_UNIT_START_DATE5JOB_DESCRIPTION3JOB_NAME9JOB_STATUS4JOB_TYPE54LAST_UNIT_COMPLETION_DATE53LAST_UNIT_START_DATE31LINE41LOT_NUMBER50MINIMUM_TRANSFER_QUANTITY12MRP_NET_QUANTITY45OPERATION_CODE55OPERATION_DESCRIPTION44OPERATION_SEQ_NUM1ORGANIZATION_CODE42OVERCOMPLETION_TOLERANCE_TYPE43OVERCOMPLETION_TOLERANCE_VALUE32PROJECT36REQUESTED_DUE_DATE35REQUESTED_START_DATE59RESOURCE_BASIS66RESOURCE_COMPLETION_DATE56RESOURCE_SEQ_NUM65RESOURCE_START_DATE57RESOURCE_SUB_ELEMENT58RESOURCE_UOM23ROUTING_ALTERNATE_DESIGNATOR21ROUTING_REFERENCE22ROUTING_REFERENCE_DESCRIPTION25ROUTING_REVISION26ROUTING_REVISION_DATE62SCHEDULED14SCHEDULED_COMPLETION_DATE13SCHEDULED_START_DATE29SCHEDULE_GROUP63SCHEDULE_SEQ_NUM37SCHEDULING_PRIORITY24SERIALIZATION_START_OP11START_QUANTITY20SUPPLY_TYPE33TASK2UPLOAD_JOB_IDENTIFIER60USAGE_RATE_OR_AMOUNTSSiteJob HeadersCreate/Update WIP Job Headers only.ERIC.CLEGG6ASSEMBLY7ASSEMBLY_DESCRIPTION17BOM_ALTERNATE_DESIGNATOR15BOM_REFERENCE16BOM_REFERENCE_DESCRIPTION18BOM_REVISION19BOM_REVISION_DATE30BUILD_SEQUENCE8CLASS_CODE28COMPLETION_LOCATOR27COMPLETION_SUBINVENTORY40DEMAND_CLASS38DUE_DATE_PENALTY39DUE_DATE_TOLERANCE34END_ITEM_UNIT_NUMBER10FIRM45JOB_ATTRIBUTE154JOB_ATTRIBUTE1055JOB_ATTRIBUTE1156JOB_ATTRIBUTE1257JOB_ATTRIBUTE1358JOB_ATTRIBUTE1459JOB_ATTRIBUTE1546JOB_ATTRIBUTE247JOB_ATTRIBUTE348JOB_ATTRIBUTE449JOB_ATTRIBUTE550JOB_ATTRIBUTE651JOB_ATTRIBUTE752JOB_ATTRIBUTE853JOB_ATTRIBUTE944JOB_ATTRIBUTE_CATEGORY5JOB_DESCRIPTION3JOB_NAME9JOB_STATUS4JOB_TYPE31LINE41LOT_NUMBER12MRP_NET_QUANTITY1ORGANIZATION_CODE42OVERCOMPLETION_TOLERANCE_TYPE43OVERCOMPLETION_TOLERANCE_VALUE32PROJECT36REQUESTED_DUE_DATE35REQUESTED_START_DATE23ROUTING_ALTERNATE_DESIGNATOR21ROUTING_REFERENCE22ROUTING_REFERENCE_DESCRIPTION25ROUTING_REVISION26ROUTING_REVISION_DATE14SCHEDULED_COMPLETION_DATE13SCHEDULED_START_DATE29SCHEDULE_GROUP37SCHEDULING_PRIORITY24SERIALIZATION_START_OP11START_QUANTITY20SUPPLY_TYPE33TASK2UPLOAD_JOB_IDENTIFIERSSiteDownload ComponentsDownload OperationsERIC.CLEGGJob Headers1ACTION_Charvarchar22STATUS_Charvarchar23MESSAGE_Charvarchar24REQUEST_ID_Charvarchar2Y5MODIFIED_COLUMNS_Charvarchar2Y6JOB_ROWIDCharvarchar2Y7OPERATION_ROWIDCharvarchar2Y8RESOURCE_ROWIDCharvarchar2Y9COMPONENT_ROWIDCharvarchar2Y10AUTO_GENERATE_JOB_NAMECharvarchar2:$flex$.Auto_Generate_Job_NameYY11ORGANIZATION_CODELOVvarchar2INV Organization Code8E2FF36EDEB279D2E0530100007F1FF2Yselect
ood.organization_code value,
ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description
from
org_organization_definitions ood,
mtl_parameters mp,
mtl_parameters mp0,
hr_all_organization_units haou,
hr_locations_all hla,
fnd_territories_vl ftv
where
ood.organization_id=mp.organization_id and
mp.organization_id<>mp.master_organization_id and
(
ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or
not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11)
) and
(:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and
(:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and
nvl(ood.disable_date,sysdate)>=sysdate and
mp.master_organization_id=mp0.organization_id and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+)
order by
ood.organization_codeselect mp.organization_id id, mp.organization_code value from mtl_parameters mp:$flex$.Organization_CodeYY12UPLOAD_JOB_IDENTIFIERCharvarchar2A unique identifier used to group the header, operation, resource and component rows belonging to the same WIP Job in the upload. For existing jobs (update mode), this is populated with the current Job Name. For new jobs, enter any meaningful reference to identify the job in the upload and results. This value is retained in the results for traceability. If Auto Generate Job Name is set to No (manual job names) and the Job Name column is left blank, this value will also be used as the WIP Job Name.YY13JOB_NAMECharvarchar2The actual WIP Job Name as stored in Oracle. For new jobs with Auto Generate Job Name set to Yes, leave this blank — the auto-generated name will be shown in the results. For new jobs with Auto Generate Job Name set to No, leave blank to use the Upload Job Identifier as the Job Name, or enter a specific name if different. For existing jobs, this shows the current Job Name and can be changed to rename the job.14JOB_TYPELOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='WIP_DISCRETE_JOB' order by 1YY15JOB_DESCRIPTIONCharvarchar216ASSEMBLYLOV customvarchar2YYselect
msiv.inventory_item_id id,
msiv.concatenated_segments value,
msiv.description
from
mtl_system_items_vl msiv
where
msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
msiv.bom_item_type in (1,2,4) and
msiv.pick_components_flag='N'
order by 1Y17ASSEMBLY_DESCRIPTIONCharvarchar2select msiv.description from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=:$column$.assemblyY18CLASS_CODELOV customvarchar2Yselect
wdcav.class_code value,
wdcav.description
from
wip_discrete_classes_all_v wdcav
where
wdcav.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
(:$column$.job_type=xxen_util.meaning(1,'WIP_DISCRETE_JOB',700) and wdcav.class_type=1 or :$column$.job_type=xxen_util.meaning(3,'WIP_DISCRETE_JOB',700) and wdcav.class_type in (3,4))
order by 1Y19JOB_STATUSLOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='WIP_JOB_STATUS' and ml.lookup_code in (1,3,4,6,7) order by 1xxen_util.meaning(1,'WIP_JOB_STATUS',700)Y20FIRMLOV Oraclevarchar2BOM_SYS_YES_NOYselect
to_char(lookup_code) id,
meaning value,
null description
from
mfg_lookups
where
lookup_type='SYS_YES_NO'
order by value,descriptionxxen_util.meaning(2,'SYS_YES_NO',700)21START_QUANTITYNumbernumberY22MRP_NET_QUANTITYNumbernumbernvl2(:$column$.assembly,:$column$.start_quantity,0)Y23SCHEDULED_START_DATEDateTimedate24SCHEDULED_COMPLETION_DATEDateTimedate25QUANTITY_REMAININGNumbernumberThis is for information only. It is not used by the upload.Y26QUANTITY_COMPLETEDNumbernumberThis is for information only. It is not used by the upload.Y27QUANTITY_SCRAPPEDNumbernumberThis is for information only. It is not used by the upload.Y28DATE_RELEASEDDateTimedateThis is for information only. It is not used by the upload.Y29DATE_COMPLETEDDateTimedateThis is for information only. It is not used by the upload.Y30DATE_CLOSEDDateTimedateThis is for information only. It is not used by the upload.Y31BOM_REFERENCELOV customvarchar2YYselect
msiv.inventory_item_id id,
msiv.concatenated_segments value,
msiv.description
from
mtl_system_items_vl msiv
where
msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
msiv.bom_item_type in (1,2,4) and
:$column$.job_type=xxen_util.meaning(3,'WIP_DISCRETE_JOB',700)
order by 132BOM_REFERENCE_DESCRIPTIONCharvarchar2select msiv.description from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=:$column$.bom_referenceY33BOM_ALTERNATE_DESIGNATORLOV customvarchar2Yselect
bba.alternate_bom_designator value,
bba.description
from
bom_bill_alternates_v bba
where
bba.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
bba.assembly_item_id=(select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=decode(:$column$.job_type,xxen_util.meaning(1,'WIP_DISCRETE_JOB',700),:$column$.assembly,:$column$.bom_reference)) and
(bba.assembly_type=1 or fnd_profile.value('WIP_SEE_ENG_ITEMS')=1) and
(bba.alternate_bom_designator is null or bba.alternate_bom_designator not in (select bad.alternate_designator_code from bom_alternate_designators bad where bad.disable_date<sysdate and bad.organization_id=bba.organization_id))
order by decode(bba.alternate_bom_designator,null,'0','1'||bba.alternate_bom_designator)34BOM_REVISIONLOV customvarchar2Yselect
bbnhrv.revision value,
to_char(bbnhrv.effectivity_date,'DD-MON-YYYY') description
from
bom_bill_no_hold_revisions_v bbnhrv
where
bbnhrv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
bbnhrv.inventory_item_id=(select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id=bbnhrv.organization_id and msiv.concatenated_segments=decode(:$column$.job_type,xxen_util.meaning(1,'WIP_DISCRETE_JOB',700),:$column$.assembly,:$column$.bom_reference))
order by bbnhrv.effectivity_date desc, bbnhrv.revision35BOM_REVISION_DATEDateTimedateselect sysdate from dual where :$column$.bom_revision is not null36SUPPLY_TYPELOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='WIP_SUPPLY' and
ml.lookup_code in (1,2,3,4,5,7) and
(:$column$.job_type<>xxen_util.meaning(3,'WIP_DISCRETE_JOB',700) or :$column$.assembly is not null or ml.lookup_code in (1,4,5,7))
order by 137ROUTING_REFERENCELOV customvarchar2YYselect
msiv.inventory_item_id id,
msiv.concatenated_segments value,
msiv.description
from
mtl_system_items_vl msiv
where
msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
:$column$.job_type=xxen_util.meaning(3,'WIP_DISCRETE_JOB',700)
order by 138ROUTING_REFERENCE_DESCRIPTIONCharvarchar2select msiv.description from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=:$column$.routing_referenceY39ROUTING_ALTERNATE_DESIGNATORLOV customvarchar2Yselect
bra.alternate_routing_designator value,
bra.description
from
bom_routing_alternates_v bra
where
bra.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
bra.assembly_item_id=(select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=decode(:$column$.job_type,xxen_util.meaning(1,'WIP_DISCRETE_JOB',700),:$column$.assembly,:$column$.routing_reference)) and
bra.pending_from_ecn is null and
nvl(bra.cfm_routing_flag,2)=2 and
(bra.routing_type=1 or fnd_profile.value('WIP_SEE_ENG_ITEMS')=1)
order by decode(bra.alternate_routing_designator,null,'0','1'||bra.alternate_routing_designator)40SERIALIZATION_START_OPNumbernumber41ROUTING_REVISIONLOV customvarchar2Yselect
mrrhv.process_revision value,
to_char(mrrhv.effectivity_date,'DD-MON-YYYY') description
from
mtl_routing_rev_highdate_v mrrhv
where
mrrhv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
mrrhv.inventory_item_id=(select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id=mrrhv.organization_id and msiv.concatenated_segments=decode(:$column$.job_type,xxen_util.meaning(1,'WIP_DISCRETE_JOB',700),:$column$.assembly,:$column$.routing_reference))
order by mrrhv.effectivity_date desc, mrrhv.process_revision42ROUTING_REVISION_DATEDateTimedateselect sysdate from dual where :$column$.routing_revision is not null43COMPLETION_SUBINVENTORYLOV customvarchar2Yselect
msi.secondary_inventory_name value,
msi.description
from
mtl_secondary_inventories msi
where
msi.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
order by 144COMPLETION_LOCATORLOV customvarchar2Yselect
milk.inventory_location_id id,
milk.concatenated_segments value,
milk.description
from
mtl_item_locations_kfv milk
where
milk.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
milk.subinventory_code=:$column$.completion_subinventory and
nvl(milk.disable_date,sysdate+1)>sysdate
order by milk.concatenated_segments45SCHEDULE_GROUPLOV customvarchar2Yselect
wsg.schedule_group_id id,
wsg.schedule_group_name value,
wsg.description
from
wip_schedule_groups wsg
where
wsg.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
nvl(wsg.inactive_on,sysdate+1)>sysdate
order by 146BUILD_SEQUENCENumbernumber47LINELOV customvarchar2Yselect
wl.line_id id,
wl.line_code value,
wl.description
from
wip_lines wl
where
wl.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
order by 148PROJECTLOV customvarchar2YYselect
ppv.project_id id,
ppv.project_number value,
ppv.project_name description
from
pjm_projects_v ppv,
pjm_project_parameters ppp
where
ppp.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
ppv.project_id=ppp.project_id
order by ppv.project_number49TASKLOV customvarchar2Yselect
pt.task_id id,
pt.task_number value,
pt.task_name description
from
pa_tasks pt
where
pt.project_id=(select ppmv.project_id from pjm_projects_mtll_v ppmv where ppmv.project_number=:$column$.project)
order by 150END_ITEM_UNIT_NUMBERLOV customvarchar2Yselect
punlv.unit_number value,
punlv.end_item_number description
from
pjm_unit_numbers_lov_v punlv
where
punlv.end_item_id=(select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=:$column$.assembly)
order by punlv.unit_number51REQUESTED_START_DATEDateTimedate52REQUESTED_DUE_DATEDateTimedate53SCHEDULING_PRIORITYNumbernumber1054DUE_DATE_PENALTYNumbernumber55DUE_DATE_TOLERANCENumbernumber56DEMAND_CLASSLOV customvarchar2Yselect
fcl.lookup_code value,
fcl.meaning description
from
fnd_common_lookups fcl
where
fcl.lookup_type='DEMAND_CLASS' and
fcl.enabled_flag='Y' and
sysdate between nvl(fcl.start_date_active,sysdate) and nvl(fcl.end_date_active,sysdate)
order by fcl.lookup_code57LOT_NUMBERCharvarchar258OVERCOMPLETION_TOLERANCE_TYPELOV customvarchar2Yselect
ml.lookup_code id,
ml.meaning value,
null description
from
mfg_lookups ml
where
ml.lookup_type='WIP_TOLERANCE_TYPE' and
:$column$.assembly is not null
order by 159OVERCOMPLETION_TOLERANCE_VALUENumbernumber60EXPLODE_BOM_AND_ROUTINGLOV Oraclevarchar2BOM_SYS_YES_NOYselect
to_char(lookup_code) id,
meaning value,
null description
from
mfg_lookups
where
lookup_type='SYS_YES_NO'
order by value,descriptionControls whether the BOM and routing are exploded when creating or updating a job. Yes = explode BOM/routing to create operations, resources, and components from the standard definitions. No = do not explode, preserving any manually-added or uploaded detail rows. If left blank: for creates with detail rows, defaults to No; for creates without detail rows, defaults to Yes; for updates, defaults to No.Y61SOURCE_CODECharvarchar2Y62SOURCE_LINE_IDNumbernumberY63JOB_ATTRIBUTE_CATEGORYLOV customvarchar2Yselect
fdfcv.descriptive_flex_context_code id,
fdfcv.descriptive_flex_context_name value,
fdfcv.description
from
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=706 and
fdfcv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfcv.enabled_flag='Y' and
fdfcv.descriptive_flex_context_code<>'Global Data Elements'
order by 264JOB_ATTRIBUTE1LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE1',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE1'65JOB_ATTRIBUTE2LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE2',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE2'66JOB_ATTRIBUTE3LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE3',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE3'67JOB_ATTRIBUTE4LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE4',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE4'68JOB_ATTRIBUTE5LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE5',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE5'69JOB_ATTRIBUTE6LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE6',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE6'70JOB_ATTRIBUTE7LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE7',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE7'71JOB_ATTRIBUTE8LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE8',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE8'72JOB_ATTRIBUTE9LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE9',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE9'73JOB_ATTRIBUTE10LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE10',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE10'74JOB_ATTRIBUTE11LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE11',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE11'75JOB_ATTRIBUTE12LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE12',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE12'76JOB_ATTRIBUTE13LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE13',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE13'77JOB_ATTRIBUTE14LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE14',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE14'78JOB_ATTRIBUTE15LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>706,
p_descriptive_flexfield_name=>'WIP_DISCRETE_JOBS',
p_context_name=>:$column$.job_attribute_category,
p_column_name=>'ATTRIBUTE15',
p_attribute1=>:$column$.job_attribute1,
p_attribute2=>:$column$.job_attribute2,
p_attribute3=>:$column$.job_attribute3,
p_attribute4=>:$column$.job_attribute4,
p_attribute5=>:$column$.job_attribute5,
p_attribute6=>:$column$.job_attribute6,
p_attribute7=>:$column$.job_attribute7,
p_attribute8=>:$column$.job_attribute8,
p_attribute9=>:$column$.job_attribute9,
p_attribute10=>:$column$.job_attribute10,
p_attribute11=>:$column$.job_attribute11,
p_attribute12=>:$column$.job_attribute12,
p_attribute13=>:$column$.job_attribute13,
p_attribute14=>:$column$.job_attribute14,
p_attribute15=>:$column$.job_attribute15
)
) lovselect distinct
'('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfv.application_id=706 and
fdfv.descriptive_flexfield_name='WIP_DISCRETE_JOBS' and
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfcuv.application_column_name='ATTRIBUTE15'79OPERATION_SEQ_NUMNumbernumberY80OPERATION_CODELOV customvarchar2Yselect
bso.standard_operation_id id,
bso.operation_code value,
bso.operation_description description
from
bom_standard_operations bso
where
bso.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
nvl(bso.operation_type,1)=1
order by 181DEPARTMENTLOV customvarchar2Yselect
bd.department_id id,
bd.department_code value,
bd.description
from
bom_departments bd
where
bd.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
order by 182COUNT_POINTLOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='BOM_COUNT_POINT_TYPE' order by 183AUTOCHARGELOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='BOM_AUTOCHARGE_TYPE' order by 184BACKFLUSHLOV Oraclevarchar2BOM_SYS_YES_NOYselect
to_char(lookup_code) id,
meaning value,
null description
from
mfg_lookups
where
lookup_type='SYS_YES_NO'
order by value,description85MINIMUM_TRANSFER_QUANTITYNumbernumber86FIRST_UNIT_START_DATEDateTimedate87FIRST_UNIT_COMPLETION_DATEDateTimedate88LAST_UNIT_START_DATEDateTimedate89LAST_UNIT_COMPLETION_DATEDateTimedate90OPERATION_DESCRIPTIONCharvarchar291RESOURCE_SEQ_NUMNumbernumberY92RESOURCE_SUB_ELEMENTLOV customvarchar2Yselect
br.resource_id id,
br.resource_code value,
br.description
from
bom_resources br
where
br.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
order by 193RESOURCE_UOMCharvarchar2Y94RESOURCE_BASISLOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='CST_BASIS' and ml.lookup_code in (1,2) order by 195USAGE_RATE_OR_AMOUNTNumbernumber96ASSIGNED_UNITSNumbernumber97SCHEDULEDLOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='BOM_RESOURCE_SCHEDULE_TYPE' order by 198SCHEDULE_SEQ_NUMNumbernumber99ACTIVITYLOV customvarchar2Yselect
ca.activity_id id,
ca.activity value,
ca.description
from
cst_activities ca
where
nvl(ca.organization_id,(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code))=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
nvl(ca.disable_date,sysdate+2)>sysdate
order by ca.activity100RESOURCE_START_DATEDateTimedate101RESOURCE_COMPLETION_DATEDateTimedate102COMPONENTLOV customvarchar2YYselect
msiv.inventory_item_id id,
msiv.concatenated_segments value,
msiv.description
from
mtl_system_items_vl msiv
where
msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
order by 1103COMPONENT_DESCRIPTIONCharvarchar2select msiv.description from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=:$column$.componentY104COMPONENT_UOMCharvarchar2select msiv.primary_uom_code from mtl_system_items_vl msiv where msiv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and msiv.concatenated_segments=:$column$.componentY105COMPONENT_OPERATION_SEQ_NUMNumbernumber106COMPONENT_DEPARTMENTLOV customvarchar2Yselect
bd.department_id id,
bd.department_code value,
bd.description
from
bom_departments bd
where
bd.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
order by 1107COMPONENT_DATE_REQUIREDDateTimedate108COMPONENT_BASISLOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='CST_BASIS' and ml.lookup_code in (1,2) order by 1109COMPONENT_QUANTITY_PER_ASSEMBLYNumbernumber110COMPONENT_REQUIRED_QUANTITYNumbernumberY111COMPONENT_YIELD_FACTORNumbernumber112COMPONENT_SUPPLY_TYPELOV customvarchar2Yselect ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' and ml.lookup_code in (1,2,3,4,5,6,7) order by 1113COMPONENT_SUPPLY_SUBINVENTORYLOV customvarchar2Yselect
msi.secondary_inventory_name value,
msi.description
from
mtl_secondary_inventories msi
where
msi.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code)
order by 1114COMPONENT_SUPPLY_LOCATORLOV customvarchar2Yselect
milk.inventory_location_id id,
milk.concatenated_segments value,
milk.description
from
mtl_item_locations_kfv milk
where
milk.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) and
milk.subinventory_code=:$column$.component_supply_subinventory and
nvl(milk.disable_date,sysdate+1)>sysdate
order by milk.concatenated_segments115COMPONENT_MRP_NETLOV Oraclevarchar2BOM_SYS_YES_NOYselect
to_char(lookup_code) id,
meaning value,
null description
from
mfg_lookups
where
lookup_type='SYS_YES_NO'
order by value,description116WIP_ENTITY_IDNumbernumberY117ORGANIZATION_IDNumbernumberY118COMPONENT_ITEM_IDNumbernumberY119ROW_TYPE_SORTNumbernumberY120UPLOAD_ROWNumbernumberYU5p_actioninCharYACTION_CODE_U10status_outCharSTATUS_CODE_U20message_outCharMESSAGE_U30p_wip_entity_idinNumberYWIP_ENTITY_IDU35p_organization_idinNumberYORGANIZATION_CODEU36p_auto_generateinCharYAUTO_GENERATE_JOB_NAMEU37p_allow_explosioninNumberYEXPLODE_BOM_AND_ROUTINGU40p_upload_job_identifierinCharUPLOAD_JOB_IDENTIFIERU45p_job_nameinCharYJOB_NAMEU50p_job_typeinNumberJOB_TYPEU60p_assembly_item_idinNumberYASSEMBLYU70p_class_codeinCharYCLASS_CODEU80p_status_typeinNumberYJOB_STATUSU90p_start_quantityinNumberYSTART_QUANTITYU100p_net_quantityinNumberYMRP_NET_QUANTITYU110p_scheduled_start_dateinDateYSCHEDULED_START_DATEU120p_scheduled_completion_dateinDateYSCHEDULED_COMPLETION_DATEU130p_firm_planned_flaginNumberYFIRMU140p_descriptioninCharYJOB_DESCRIPTIONU150p_alternate_bom_designatorinCharYBOM_ALTERNATE_DESIGNATORU160p_bom_revisioninCharYBOM_REVISIONU170p_bom_revision_dateinDateYBOM_REVISION_DATEU180p_alternate_routing_designatorinCharYROUTING_ALTERNATE_DESIGNATORU190p_routing_revisioninCharYROUTING_REVISIONU200p_routing_revision_dateinDateYROUTING_REVISION_DATEU210p_bom_reference_idinNumberYBOM_REFERENCEU220p_routing_reference_idinNumberYROUTING_REFERENCEU230p_wip_supply_typeinNumberYSUPPLY_TYPEU240p_completion_subinventoryinCharYCOMPLETION_SUBINVENTORYU250p_completion_locator_idinNumberYCOMPLETION_LOCATORU260p_schedule_group_idinNumberYSCHEDULE_GROUPU270p_build_sequenceinNumberYBUILD_SEQUENCEU280p_line_idinNumberYLINEU290p_project_idinNumberYPROJECTU300p_task_idinNumberYTASKU310p_priorityinNumberYSCHEDULING_PRIORITYU315p_requested_start_dateinDateYREQUESTED_START_DATEU320p_due_dateinDateYREQUESTED_DUE_DATEU322p_serialization_start_opinNumberYSERIALIZATION_START_OPU325p_due_date_penaltyinNumberYDUE_DATE_PENALTYU326p_due_date_toleranceinNumberYDUE_DATE_TOLERANCEU330p_lot_numberinCharYLOT_NUMBERU340p_demand_classinCharYDEMAND_CLASSU350p_end_item_unit_numberinCharYEND_ITEM_UNIT_NUMBERU360p_source_codeinCharYSOURCE_CODEU370p_source_line_idinNumberYSOURCE_LINE_IDU380p_overcompletion_tolerance_typinNumberYOVERCOMPLETION_TOLERANCE_TYPEU390p_overcompletion_tolerance_valinNumberYOVERCOMPLETION_TOLERANCE_VALUEU410p_operation_seq_numinNumberYOPERATION_SEQ_NUMU420p_standard_operation_idinNumberYOPERATION_CODEU430p_department_idinNumberYDEPARTMENTU440p_op_descriptioninCharYOPERATION_DESCRIPTIONU450p_count_point_typeinNumberYCOUNT_POINTU460p_backflush_flaginNumberYBACKFLUSHU470p_minimum_transfer_quantityinNumberYMINIMUM_TRANSFER_QUANTITYU480p_first_unit_start_dateinDateYFIRST_UNIT_START_DATEU482p_first_unit_completion_dateinDateYFIRST_UNIT_COMPLETION_DATEU485p_last_unit_start_dateinDateYLAST_UNIT_START_DATEU490p_last_unit_completion_dateinDateYLAST_UNIT_COMPLETION_DATEU500p_resource_seq_numinNumberYRESOURCE_SEQ_NUMU510p_resource_idinNumberYRESOURCE_SUB_ELEMENTU520p_resource_basis_typeinNumberYRESOURCE_BASISU530p_usage_rate_or_amountinNumberYUSAGE_RATE_OR_AMOUNTU540p_assigned_unitsinNumberYASSIGNED_UNITSU550p_autocharge_typeinNumberYAUTOCHARGEU560p_scheduled_flaginNumberYSCHEDULEDU562p_schedule_seq_numinNumberYSCHEDULE_SEQ_NUMU565p_activity_idinNumberYACTIVITYU570p_resource_start_dateinDateYRESOURCE_START_DATEU580p_resource_completion_dateinDateYRESOURCE_COMPLETION_DATEU590p_component_item_idinNumberYCOMPONENTU596p_component_item_id_originNumberYCOMPONENT_ITEM_IDU600p_quantity_per_assemblyinNumberYCOMPONENT_QUANTITY_PER_ASSEMBLYU605p_component_operation_seq_numinNumberYCOMPONENT_OPERATION_SEQ_NUMU607p_component_department_idinNumberYCOMPONENT_DEPARTMENTU608p_component_yield_factorinNumberYCOMPONENT_YIELD_FACTORU610p_component_supply_typeinNumberYCOMPONENT_SUPPLY_TYPEU620p_supply_subinventoryinCharYCOMPONENT_SUPPLY_SUBINVENTORYU625p_supply_locator_idinNumberYCOMPONENT_SUPPLY_LOCATORU630p_date_requiredinDateYCOMPONENT_DATE_REQUIREDU640p_component_basis_typeinNumberYCOMPONENT_BASISU650p_mrp_net_flaginNumberYCOMPONENT_MRP_NETU660p_job_rowidin outCharYJOB_ROWIDU670p_operation_rowidin outCharYOPERATION_ROWIDU680p_resource_rowidin outCharYRESOURCE_ROWIDU690p_component_rowidin outCharYCOMPONENT_ROWIDU695p_upload_rowinNumberYUPLOAD_ROWU700p_job_attribute_categoryinCharYJOB_ATTRIBUTE_CATEGORYU701p_job_attribute1inCharYJOB_ATTRIBUTE1U702p_job_attribute2inCharYJOB_ATTRIBUTE2U703p_job_attribute3inCharYJOB_ATTRIBUTE3U704p_job_attribute4inCharYJOB_ATTRIBUTE4U705p_job_attribute5inCharYJOB_ATTRIBUTE5U706p_job_attribute6inCharYJOB_ATTRIBUTE6U707p_job_attribute7inCharYJOB_ATTRIBUTE7U708p_job_attribute8inCharYJOB_ATTRIBUTE8U709p_job_attribute9inCharYJOB_ATTRIBUTE9U710p_job_attribute10inCharYJOB_ATTRIBUTE10U711p_job_attribute11inCharYJOB_ATTRIBUTE11U712p_job_attribute12inCharYJOB_ATTRIBUTE12U713p_job_attribute13inCharYJOB_ATTRIBUTE13U714p_job_attribute14inCharYJOB_ATTRIBUTE14U715p_job_attribute15inCharYJOB_ATTRIBUTE15P1p_organization_idinNumberORGANIZATION_CODEP2request_id_outNumberREQUEST_ID_P3status_outCharSTATUS_CODE_P4message_outCharMESSAGE_Error SQLselect
xu.action_,
xxen_upload.status_meaning(xxen_upload.status_error) status_,
coalesce(
(select listagg(wie.error,chr(10)) within group (order by wie.interface_id) from wip_interface_errors wie, wip_job_dtls_interface wjdi where wie.interface_id=wjdi.interface_id and wjdi.rowid in (chartorowid(xu.operation_rowid),chartorowid(xu.resource_rowid),chartorowid(xu.component_rowid)) and wie.error_type=1),
(select listagg(wie.error,chr(10)) within group (order by wie.interface_id) from wip_interface_errors wie, wip_job_schedule_interface wjsi where wie.interface_id=wjsi.interface_id and wjsi.rowid=chartorowid(xu.job_rowid) and wie.error_type=1),
xu.message_,
'No error message returned. Check the WIP Mass Load concurrent request.'
) message_,
xu.request_id_,
xu.modified_columns_,
xu.job_rowid,
xu.operation_rowid,
xu.resource_rowid,
xu.component_rowid,
xu.auto_generate_job_name,
-- Job
xu.organization_code,
xu.upload_job_identifier,
xu.job_name,
xu.job_type,
xu.job_description,
xu.assembly,
xu.assembly_description,
xu.class_code,
xu.job_status,
xu.firm,
xu.start_quantity,
xu.mrp_net_quantity,
xu.scheduled_start_date,
xu.scheduled_completion_date,
xu.quantity_remaining,
xu.quantity_completed,
xu.quantity_scrapped,
xu.date_released,
xu.date_completed,
xu.date_closed,
xu.bom_reference,
xu.bom_reference_description,
xu.bom_alternate_designator,
xu.bom_revision,
xu.bom_revision_date,
xu.supply_type,
xu.routing_reference,
xu.routing_reference_description,
xu.routing_alternate_designator,
xu.serialization_start_op,
xu.routing_revision,
xu.routing_revision_date,
xu.completion_subinventory,
xu.completion_locator,
xu.schedule_group,
xu.build_sequence,
xu.line,
xu.project,
xu.task,
xu.end_item_unit_number,
xu.requested_start_date,
xu.requested_due_date,
xu.scheduling_priority,
xu.due_date_penalty,
xu.due_date_tolerance,
xu.demand_class,
xu.lot_number,
xu.overcompletion_tolerance_type,
xu.overcompletion_tolerance_value,
xu.explode_bom_and_routing,
xu.source_code,
xu.source_line_id,
xu.job_attribute_category,
xu.job_attribute1,
xu.job_attribute2,
xu.job_attribute3,
xu.job_attribute4,
xu.job_attribute5,
xu.job_attribute6,
xu.job_attribute7,
xu.job_attribute8,
xu.job_attribute9,
xu.job_attribute10,
xu.job_attribute11,
xu.job_attribute12,
xu.job_attribute13,
xu.job_attribute14,
xu.job_attribute15,
-- Operations
xu.operation_seq_num,
xu.operation_code,
xu.department,
xu.count_point,
xu.autocharge,
xu.backflush,
xu.minimum_transfer_quantity,
xu.first_unit_start_date,
xu.first_unit_completion_date,
xu.last_unit_start_date,
xu.last_unit_completion_date,
xu.operation_description,
-- Resource
xu.resource_seq_num,
xu.resource_sub_element,
xu.resource_uom,
xu.resource_basis,
xu.usage_rate_or_amount,
xu.assigned_units,
xu.scheduled,
xu.schedule_seq_num,
xu.activity,
xu.resource_start_date,
xu.resource_completion_date,
-- Component
xu.component,
xu.component_description,
xu.component_uom,
xu.component_operation_seq_num,
xu.component_department,
xu.component_date_required,
xu.component_basis,
xu.component_quantity_per_assembly,
xu.component_required_quantity,
xu.component_yield_factor,
xu.component_supply_type,
xu.component_supply_subinventory,
xu.component_supply_locator,
xu.component_mrp_net,
-- IDs
xu.wip_entity_id,
xu.organization_id,
xu.component_item_id,
xu.row_type_sort,
xu.upload_row
from
xxen_wip_job_upload_3140_u xu
where
nvl(xu.status_code_,xxen_upload.status_error)<>xxen_upload.status_success or
exists (select null from wip_job_schedule_interface wjsi where xu.job_rowid is not null and wjsi.rowid=chartorowid(xu.job_rowid) and wjsi.process_status=3) or
exists (select null from wip_job_dtls_interface wjdi where wjdi.rowid in (chartorowid(xu.operation_rowid),chartorowid(xu.resource_rowid),chartorowid(xu.component_rowid)) and wjdi.process_status=3)
Order Byupload_row, upload_job_identifier, nvl(operation_seq_num,component_operation_seq_num), row_type_sort, resource_seq_num, componentSuccess SQLselect
xu.action_,
xu.status_,
(select
ltrim(
case when wdj.creation_date>=fcr.actual_start_date then ', Job created' when wdj.last_update_date>=fcr.actual_start_date then ', Job updated' end||
case when wo.wip_entity_id is not null then case when wo.creation_date>=fcr.actual_start_date then ', Operation '||wo.operation_seq_num||' created' when wo.last_update_date>=fcr.actual_start_date then ', Operation '||wo.operation_seq_num||' updated' end end||
case when wor.resource_id is not null then case when wor.creation_date>=fcr.actual_start_date then ', Resource '||wor.resource_seq_num||' created' when wor.last_update_date>=fcr.actual_start_date then ', Resource '||wor.resource_seq_num||' updated' end end||
case when wro.inventory_item_id is not null then case when wro.creation_date>=fcr.actual_start_date then ', Component '||xu.component||' created' when wro.last_update_date>=fcr.actual_start_date then ', Component '||xu.component||' updated' end end
,', ')
from fnd_concurrent_requests fcr where fcr.request_id=xu.request_id_
) message_,
xu.request_id_,
xu.modified_columns_,
xu.job_rowid,
xu.operation_rowid,
xu.resource_rowid,
xu.component_rowid,
xu.auto_generate_job_name,
-- Job
mp.organization_code,
xu.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
(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
we.wip_entity_id,
wdj.organization_id,
wro.inventory_item_id component_item_id,
xu.row_type_sort,
xu.upload_row
from
xxen_wip_job_upload_3140_u xu,
wip_entities we,
wip_discrete_jobs wdj,
mtl_parameters mp,
wip_operations wo,
wip_operation_resources wor,
mtl_system_items_vl msiv_comp,
wip_requirement_operations wro
where
xu.status_code_=xxen_upload.status_success and
nvl(xu.job_name,xu.upload_job_identifier)=we.wip_entity_name and
mp.organization_id=we.organization_id and
we.wip_entity_id=wdj.wip_entity_id and
we.organization_id=wdj.organization_id and
we.wip_entity_id=wo.wip_entity_id(+) and
we.organization_id=wo.organization_id(+) and
xu.operation_seq_num=wo.operation_seq_num(+) 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
xu.resource_seq_num=wor.resource_seq_num(+) and
msiv_comp.organization_id(+)=mp.organization_id and
msiv_comp.concatenated_segments(+)=xu.component and
we.wip_entity_id=wro.wip_entity_id(+) and
we.organization_id=wro.organization_id(+) and
nvl(xu.component_operation_seq_num,xu.operation_seq_num)=wro.operation_seq_num(+) and
nvl(xu.component_item_id,msiv_comp.inventory_item_id)=wro.inventory_item_id(+) and
not exists (select null from wip_job_schedule_interface wjsi where xu.job_rowid is not null and wjsi.rowid=chartorowid(xu.job_rowid) and wjsi.process_status=3) and
not exists (select null from wip_job_dtls_interface wjdi where wjdi.rowid in (chartorowid(xu.operation_rowid),chartorowid(xu.resource_rowid),chartorowid(xu.component_rowid)) and wjdi.process_status=3)LOV query:$column$.organization_codeORGANIZATION_CODEACTIVITYLOV query:$column$.organization_codeORGANIZATION_CODEASSEMBLYDefault value:$column$.assemblyASSEMBLYASSEMBLY_DESCRIPTIONDefault value:$column$.organization_codeORGANIZATION_CODEASSEMBLY_DESCRIPTIONDefault value:$flex$.Auto_Generate_Job_NameAuto Generate Job Name|:p_auto_generate_job_name|AUTO_GENERATE_JOB_NAMELOV query:$column$.assemblyASSEMBLYBOM_ALTERNATE_DESIGNATORLOV query:$column$.bom_referenceBOM_REFERENCEBOM_ALTERNATE_DESIGNATORLOV query:$column$.job_typeJOB_TYPEBOM_ALTERNATE_DESIGNATORLOV query:$column$.organization_codeORGANIZATION_CODEBOM_ALTERNATE_DESIGNATORLOV query:$column$.job_typeJOB_TYPEBOM_REFERENCELOV query:$column$.organization_codeORGANIZATION_CODEBOM_REFERENCEDefault value:$column$.bom_referenceBOM_REFERENCEBOM_REFERENCE_DESCRIPTIONDefault value:$column$.organization_codeORGANIZATION_CODEBOM_REFERENCE_DESCRIPTIONLOV query:$column$.assemblyASSEMBLYBOM_REVISIONLOV query:$column$.bom_referenceBOM_REFERENCEBOM_REVISIONLOV query:$column$.job_typeJOB_TYPEBOM_REVISIONLOV query:$column$.organization_codeORGANIZATION_CODEBOM_REVISIONDefault value:$column$.bom_revisionBOM_REVISIONBOM_REVISION_DATELOV query:$column$.job_typeJOB_TYPECLASS_CODELOV query:$column$.organization_codeORGANIZATION_CODECLASS_CODELOV query:$column$.completion_subinventoryCOMPLETION_SUBINVENTORYCOMPLETION_LOCATORLOV query:$column$.organization_codeORGANIZATION_CODECOMPLETION_LOCATORLOV query:$column$.organization_codeORGANIZATION_CODECOMPLETION_SUBINVENTORYLOV query:$column$.organization_codeORGANIZATION_CODECOMPONENTLOV query:$column$.organization_codeORGANIZATION_CODECOMPONENT_DEPARTMENTDefault value:$column$.componentCOMPONENTCOMPONENT_DESCRIPTIONDefault value:$column$.organization_codeORGANIZATION_CODECOMPONENT_DESCRIPTIONLOV query:$column$.component_supply_subinventoryCOMPONENT_SUPPLY_SUBINVENTORYCOMPONENT_SUPPLY_LOCATORLOV query:$column$.organization_codeORGANIZATION_CODECOMPONENT_SUPPLY_LOCATORLOV query:$column$.organization_codeORGANIZATION_CODECOMPONENT_SUPPLY_SUBINVENTORYDefault value:$column$.componentCOMPONENTCOMPONENT_UOMDefault value:$column$.organization_codeORGANIZATION_CODECOMPONENT_UOMLOV query:$column$.organization_codeORGANIZATION_CODEDEPARTMENTLOV query:$column$.assemblyASSEMBLYEND_ITEM_UNIT_NUMBERLOV query:$column$.organization_codeORGANIZATION_CODEEND_ITEM_UNIT_NUMBERLOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE1LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE1LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE1LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE1LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE1LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE1LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE1LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE1LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE1LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE1LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE1LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE1LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE1LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE1LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE1LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE1LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE10LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE10LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE10LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE10LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE10LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE10LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE10LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE10LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE10LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE10LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE10LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE10LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE10LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE10LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE10LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE10LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE11LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE11LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE11LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE11LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE11LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE11LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE11LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE11LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE11LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE11LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE11LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE11LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE11LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE11LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE11LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE11LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE12LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE12LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE12LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE12LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE12LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE12LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE12LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE12LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE12LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE12LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE12LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE12LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE12LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE12LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE12LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE12LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE13LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE13LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE13LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE13LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE13LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE13LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE13LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE13LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE13LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE13LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE13LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE13LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE13LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE13LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE13LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE13LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE14LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE14LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE14LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE14LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE14LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE14LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE14LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE14LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE14LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE14LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE14LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE14LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE14LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE14LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE14LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE14LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE15LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE15LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE15LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE15LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE15LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE15LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE15LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE15LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE15LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE15LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE15LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE15LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE15LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE15LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE15LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE15LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE2LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE2LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE2LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE2LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE2LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE2LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE2LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE2LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE2LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE2LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE2LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE2LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE2LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE2LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE2LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE2LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE3LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE3LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE3LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE3LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE3LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE3LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE3LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE3LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE3LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE3LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE3LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE3LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE3LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE3LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE3LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE3LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE4LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE4LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE4LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE4LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE4LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE4LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE4LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE4LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE4LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE4LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE4LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE4LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE4LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE4LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE4LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE4LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE5LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE5LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE5LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE5LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE5LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE5LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE5LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE5LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE5LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE5LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE5LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE5LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE5LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE5LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE5LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE5LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE6LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE6LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE6LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE6LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE6LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE6LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE6LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE6LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE6LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE6LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE6LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE6LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE6LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE6LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE6LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE6LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE7LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE7LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE7LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE7LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE7LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE7LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE7LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE7LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE7LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE7LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE7LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE7LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE7LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE7LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE7LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE7LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE8LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE8LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE8LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE8LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE8LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE8LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE8LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE8LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE8LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE8LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE8LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE8LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE8LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE8LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE8LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE8LOV query:$column$.job_attribute1JOB_ATTRIBUTE1JOB_ATTRIBUTE9LOV query:$column$.job_attribute10JOB_ATTRIBUTE10JOB_ATTRIBUTE9LOV query:$column$.job_attribute11JOB_ATTRIBUTE11JOB_ATTRIBUTE9LOV query:$column$.job_attribute12JOB_ATTRIBUTE12JOB_ATTRIBUTE9LOV query:$column$.job_attribute13JOB_ATTRIBUTE13JOB_ATTRIBUTE9LOV query:$column$.job_attribute14JOB_ATTRIBUTE14JOB_ATTRIBUTE9LOV query:$column$.job_attribute15JOB_ATTRIBUTE15JOB_ATTRIBUTE9LOV query:$column$.job_attribute2JOB_ATTRIBUTE2JOB_ATTRIBUTE9LOV query:$column$.job_attribute3JOB_ATTRIBUTE3JOB_ATTRIBUTE9LOV query:$column$.job_attribute4JOB_ATTRIBUTE4JOB_ATTRIBUTE9LOV query:$column$.job_attribute5JOB_ATTRIBUTE5JOB_ATTRIBUTE9LOV query:$column$.job_attribute6JOB_ATTRIBUTE6JOB_ATTRIBUTE9LOV query:$column$.job_attribute7JOB_ATTRIBUTE7JOB_ATTRIBUTE9LOV query:$column$.job_attribute8JOB_ATTRIBUTE8JOB_ATTRIBUTE9LOV query:$column$.job_attribute9JOB_ATTRIBUTE9JOB_ATTRIBUTE9LOV query:$column$.job_attribute_categoryJOB_ATTRIBUTE_CATEGORYJOB_ATTRIBUTE9LOV query:$column$.organization_codeORGANIZATION_CODELINEDefault value:$column$.assemblyASSEMBLYMRP_NET_QUANTITYDefault value:$column$.start_quantitySTART_QUANTITYMRP_NET_QUANTITYLOV query:$column$.organization_codeORGANIZATION_CODEOPERATION_CODEDefault value:$flex$.Organization_CodeOrganization Code|1=1|ORGANIZATION_CODELOV query:$column$.assemblyASSEMBLYOVERCOMPLETION_TOLERANCE_TYPELOV query:$column$.organization_codeORGANIZATION_CODEPROJECTLOV query:$column$.organization_codeORGANIZATION_CODERESOURCE_SUB_ELEMENTLOV query:$column$.assemblyASSEMBLYROUTING_ALTERNATE_DESIGNATORLOV query:$column$.job_typeJOB_TYPEROUTING_ALTERNATE_DESIGNATORLOV query:$column$.organization_codeORGANIZATION_CODEROUTING_ALTERNATE_DESIGNATORLOV query:$column$.routing_referenceROUTING_REFERENCEROUTING_ALTERNATE_DESIGNATORLOV query:$column$.job_typeJOB_TYPEROUTING_REFERENCELOV query:$column$.organization_codeORGANIZATION_CODEROUTING_REFERENCEDefault value:$column$.organization_codeORGANIZATION_CODEROUTING_REFERENCE_DESCRIPTIONDefault value:$column$.routing_referenceROUTING_REFERENCEROUTING_REFERENCE_DESCRIPTIONLOV query:$column$.assemblyASSEMBLYROUTING_REVISIONLOV query:$column$.job_typeJOB_TYPEROUTING_REVISIONLOV query:$column$.organization_codeORGANIZATION_CODEROUTING_REVISIONLOV query:$column$.routing_referenceROUTING_REFERENCEROUTING_REVISIONDefault value:$column$.routing_revisionROUTING_REVISIONROUTING_REVISION_DATELOV query:$column$.organization_codeORGANIZATION_CODESCHEDULE_GROUPLOV query:$column$.assemblyASSEMBLYSUPPLY_TYPELOV query:$column$.job_typeJOB_TYPESUPPLY_TYPELOV query:$column$.projectPROJECTTASKValue to id query:$column$.assemblyASSEMBLYp_overcompletion_tolerance_typValue to id query:$column$.assemblyASSEMBLYp_wip_supply_typeValue to id query:$column$.completion_subinventoryCOMPLETION_SUBINVENTORYp_completion_locator_idValue to id query:$column$.component_supply_subinventoryCOMPONENT_SUPPLY_SUBINVENTORYp_supply_locator_idValue to id query:$column$.job_typeJOB_TYPEp_bom_reference_idValue to id query:$column$.job_typeJOB_TYPEp_routing_reference_idValue to id query:$column$.job_typeJOB_TYPEp_wip_supply_typeValue to id query:$column$.organization_codeORGANIZATION_CODEp_activity_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_assembly_item_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_bom_reference_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_completion_locator_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_component_department_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_component_item_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_department_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_line_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_project_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_resource_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_routing_reference_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_schedule_group_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_standard_operation_idValue to id query:$column$.organization_codeORGANIZATION_CODEp_supply_locator_idValue to id query:$column$.projectPROJECTp_task_id