WIP Discrete Job Listing

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Discrete Job Listing Report
Application: Work in Process
Source: Discrete Job Listing Report (XML)
Short Name: WIPDJLIS_XML
DB package: WIP_WIPDJLIS_XMLP_PKG
Run WIP Discrete Job Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT WE.WIP_ENTITY_NAME Name,
       ML1.MEANING Type,
       &P_ITEM_DATA C_ITEM_DATA,
       SI.PRIMARY_UOM_CODE UOM,
       ML2.MEANING Status,
       DJ.START_QUANTITY Sched_Qty,
       DJ.QUANTITY_COMPLETED Qty_Completed,
       DJ.QUANTITY_SCRAPPED Qty_Scrapped,
       DJ.SCHEDULED_START_DATE Start_Date,
       DJ.SCHEDULED_COMPLETION_DATE Complete_Date,
       NVL(SI.INVENTORY_ITEM_ID,-1) Item_Id,
       SG.SCHEDULE_GROUP_NAME Schedule_Group_Name,
       DJ.BUILD_SEQUENCE Build_Sequence, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, SI.ORGANIZATION_ID, SI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_VALUE,
	   to_char(DJ.SCHEDULED_START_DATE,'DD-MON-YY') Start_Date1,
       to_char(DJ.SCHEDULED_COMPLETION_DATE,'DD-MON-YY') Complete_Date1
FROM   MFG_LOOKUPS ML1,
       MFG_LOOKUPS ML2,
       MTL_SYSTEM_ITEMS SI,
       WIP_SCHEDULE_GROUPS SG,
       WIP_ENTITIES WE,
       WIP_DISCRETE_JOBS DJ
WHERE  DJ.ORGANIZATION_ID = :ORG_ID
AND    SG.ORGANIZATION_ID &P_SG_OUTER = DJ.ORGANIZATION_ID
AND    SG.SCHEDULE_GROUP_ID &P_SG_OUTER = DJ.SCHEDULE_GROUP_ID
AND    WE.ORGANIZATION_ID = :ORG_ID
AND    SI.ORGANIZATION_ID &P_OUTER = DJ.ORGANIZATION_ID
AND    WE.WIP_ENTITY_ID = DJ.WIP_ENTITY_ID
AND    WE.ENTITY_TYPE in (1,3,5,8) 
AND    DJ.PRIMARY_ITEM_ID = SI.INVENTORY_ITEM_ID &P_OUTER
AND    ML1.LOOKUP_TYPE = 'WIP_DISCRETE_JOB'
AND    ML1.LOOKUP_CODE = DJ.JOB_TYPE
AND    ML2.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND    ML2.LOOKUP_CODE = DJ.STATUS_TYPE
AND    &P_ITEM_WHERE
&P_ITEM_ORG
&C_Job_Limiter
&C_Date_Limiter
&C_Status_Limiter
&C_Schedule_Group
ORDER BY &C_Order_By, DJ.STATUS_TYPE,WE.WIP_ENTITY_ID
Parameter Name SQL text Validation
Sort By
 
LOV Oracle
Jobs From
 
LOV Oracle
To
 
LOV Oracle
Assemblies From
 
Char
To 2
 
Char
Start Dates From
 
Date
To 3
 
Date
Status
 
LOV Oracle
Schedule Group From
 
LOV Oracle
Schedule Group To
 
LOV Oracle