WIP Repetitive Line

Description

Imported from BI Publisher
Description: Repetitive Line Report
Application: Work in Process
Source: Repetitive Line Report (XML)
Short Name: WIPRELIN_XML
DB package: WIP_WIPRELIN_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

SELECT WL.LINE_CODE Line 
,WL.LINE_ID Line_Id
,LU1.MEANING Scheduling_Base
,WL.MINIMUM_RATE Minimum_Daily_Rate
,TO_CHAR(TO_DATE(WL.START_TIME, 'SSSSS'), 'HH24:MI') Start_Time
,WL.DISABLE_DATE Disable_Date
,WL.FIXED_THROUGHPUT Leadtime_Hours
,WL.MAXIMUM_RATE Maximum_Daily_Rate
,TO_CHAR(TO_DATE(WL.STOP_TIME, 'SSSSS'), 'HH24:MI') Stop_Time
,WL.DESCRIPTION Description
,DECODE(RS.STATUS_TYPE, 13,2,1) Status_Group
,WE.WIP_ENTITY_NAME C_ASSY
,WE.DESCRIPTION Description1
,MSI.PRIMARY_UOM_CODE UOM
,LU2.MEANING Status
,RS.DAILY_PRODUCTION_RATE Rate
,RS.PROCESSING_WORK_DAYS Days
,(RS.DAILY_PRODUCTION_RATE * RS.PROCESSING_WORK_DAYS) Quantity
,TO_CHAR(RS.FIRST_UNIT_START_DATE,'DD-MON-YY') fus_date
,TO_CHAR(RS.FIRST_UNIT_START_DATE,'HH24:MI') fus_Time
,TO_CHAR(RS.LAST_UNIT_COMPLETION_DATE,'DD-MON-YY') luc_date
,TO_CHAR(RS.LAST_UNIT_COMPLETION_DATE,'HH24:MI') luc_Time
,RS.QUANTITY_COMPLETED Completed
FROM MFG_LOOKUPS LU1
,WIP_REPETITIVE_SCHEDULES RS
,WIP_REPETITIVE_ITEMS RI
,MFG_LOOKUPS LU2
,MTL_SYSTEM_ITEMS MSI
,WIP_ENTITIES WE 
,WIP_LINES WL
WHERE WL.ORGANIZATION_ID = :P_ORGANIZATION_ID
&C_Limit_Lines
AND LU1.LOOKUP_TYPE = 'WIP_LINE_SCHED_TYPE'
AND LU1.LOOKUP_CODE = WL.LINE_SCHEDULE_TYPE
AND RS.ORGANIZATION_ID = :P_ORGANIZATION_ID
AND RS.LINE_ID = WL.LINE_ID
AND WE.ENTITY_TYPE = 2
AND RS.STATUS_TYPE IN (1,3,4,6,13)
&C_Limit_Dates
AND RI.ORGANIZATION_ID = :P_ORGANIZATION_ID
AND RI.LINE_ID = WL.LINE_ID
AND RI.WIP_ENTITY_ID = RS.WIP_ENTITY_ID
AND MSI.ORGANIZATION_ID = RI.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = RI.PRIMARY_ITEM_ID
AND WE.ORGANIZATION_ID = :P_ORGANIZATION_ID
AND WE.WIP_ENTITY_ID = RS.WIP_ENTITY_ID
&C_Limit_Assemblies
AND LU2.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND LU2.LOOKUP_CODE = RS.STATUS_TYPE
ORDER BY WL.LINE_CODE, DECODE(RS.STATUS_TYPE, 13,2,1),
         RS.FIRST_UNIT_START_DATE, 
         RS.LAST_UNIT_COMPLETION_DATE, WE.WIP_ENTITY_NAME