WIP Discrete Job Listing

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: Discrete Job Listing Report (XML)
Short Name: WIPDJLIS_XML
DB package: WIP_WIPDJLIS_XMLP_PKG
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
Quantity Field Precision
 
Number
Org_Id
 
Number
Schedule Group To
 
LOV Oracle
Schedule Group From
 
LOV Oracle
Status
 
LOV Oracle
To
 
Date
Start Dates From
 
Date
To
 
Assemblies From
 
To
 
LOV Oracle
Jobs From
 
LOV Oracle
Sort By
 
LOV Oracle