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
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 |