WIP Job and Schedule Interface

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Job and Schedule Interface Report
Application: Work in Process
Source: Job and Schedule Interface Report (XML)
Short Name: WIPMLINT_XML
DB package: WIP_WIPMLINT_XMLP_PKG
Run WIP Job and Schedule Interface and other Oracle EBS reports with Blitz Report™ on our demo environment
select
  wjsi.source_code
, nvl(ood.organization_code, wjsi.organization_code) organization_code
, nvl(we.wip_entity_name,wjsi.job_name) job_name
, nvl(&P_FLEXDATA,' ') description
, msi.inventory_item_id
,nvl(wjsi.status_type,wdj.status_type) status_type
, nvl(wjsi.start_quantity,wdj.start_quantity) start_quantity
, to_char(nvl(wjsi.first_unit_start_date,wdj.scheduled_start_date))  
||' '||
  to_char(nvl(wjsi.first_unit_start_date,wdj.scheduled_start_date),
 'HH24:MI') start_date
, to_char(nvl(wjsi.last_unit_completion_date,
                       wdj.scheduled_completion_date))||' '||
  to_char(nvl(wjsi.last_unit_completion_date,
                       wdj.scheduled_completion_date),'HH24:MI') completion_date
,wjsi.process_phase pphase
, ml1.meaning process_phase
, ml2.meaning process_status
, wjsi.interface_id interface_id2, 
	WIP_WIPMLINT_XMLP_PKG.c_status_typeformula(nvl ( wjsi.status_type , wdj.status_type )) C_STATUS_TYPE, 
	WIP_WIPMLINT_XMLP_PKG.c_flexfield2formula() C_FLEXFIELD2, 
	WIP_WIPMLINT_XMLP_PKG.c_fail_resformula() C_Fail_Res, 
	WIP_WIPMLINT_XMLP_PKG.c_success_rescheduleformula(wjsi.process_phase) C_SUCCESS_RESCHEDULE
from 
  mtl_system_items msi 
, org_organization_definitions ood
, mfg_lookups ml1
, mfg_lookups ml2
, wip_entities we 
, wip_job_schedule_interface wjsi
, wip_discrete_jobs wdj
where wjsi.load_type = 3
and msi.inventory_item_id(+)=we.primary_item_id
and msi.organization_id(+)=we.organization_id
and ood.organization_id(+)=wjsi.organization_id
and ml1.lookup_code(+) = wjsi.process_phase
and ml1.lookup_type(+) = 'WIP_ML_PROCESS_PHASE'
and ml2.lookup_code(+) = wjsi.process_status
and ml2.lookup_type(+) = 'WIP_PROCESS_STATUS'
and wdj.wip_entity_id(+) = wjsi.wip_entity_id
and wdj.organization_id(+) = wjsi.organization_id
and we.wip_entity_id(+) = wjsi.wip_entity_id
&C_GROUP_ID
Parameter Name SQL text Validation
Group ID 
 
 Number
Include Warnings 
 
 LOV Oracle
Download
Related Blitz Reports
CAC Receiving Value (Period-End) CAC WIP Account Summary CAC WIP Account Detail CAC WIP Jobs With Complete Status Which Are Ready for Close CAC WIP Jobs With Complete Status But Not Ready for Close CAC Receiving Activity Summary CAC Missing Material Accounting Transactions CAC WIP Account Value OPM WIP Value
Blitz Report™

Blitz Report™ provides multiple benefits: