WIP Production Line
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Production Line Report
Application: Work in Process
Source: Production Line Report (XML)
Short Name: WIPSULIN_XML
DB package: WIP_WIPSULIN_XMLP_PKG
Description: Production Line Report
Application: Work in Process
Source: Production Line Report (XML)
Short Name: WIPSULIN_XML
DB package: WIP_WIPSULIN_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
SELECT WL.LINE_CODE Line, WL.Line_Id Line_Id, WL.DESCRIPTION Line_Descr, WL.DISABLE_DATE Line_Disable_Date, WL.MINIMUM_RATE Min_Rate, WL.MAXIMUM_RATE Max_Rate, WL.FIXED_THROUGHPUT Throughput, ML1.MEANING Sched_Base, WE.WIP_ENTITY_NAME Assembly, SI.DESCRIPTION Item_Descr, WRI.ALTERNATE_BOM_DESIGNATOR Alt_BOM, WRI.ALTERNATE_ROUTING_DESIGNATOR Alt_Routing, WRI.CLASS_CODE Rep_Class_Code, WRI.PRODUCTION_LINE_RATE Line_Speed, WRI.LOAD_DISTRIBUTION_PRIORITY Priority, ML2.MEANING Primary_Line, ML3.MEANING Supply_Type, WRI.COMPLETION_SUBINVENTORY Completion_Sub, DECODE(WRI.COMPLETION_LOCATOR_ID,NULL,NULL,&P_LOCATOR_DATA) C_LOCATOR_DATA, DECODE(WRI.COMPLETION_LOCATOR_ID,NULL,NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_value', 'INV', 'MTLL', 101, IL.ORGANIZATION_ID, IL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) C_LOCATOR_VALUE FROM MFG_LOOKUPS ML3, MFG_LOOKUPS ML2, MFG_LOOKUPS ML1, MTL_SYSTEM_ITEMS SI, MTL_ITEM_LOCATIONS IL, WIP_REPETITIVE_ITEMS WRI, WIP_ENTITIES WE, WIP_LINES WL WHERE WL.ORGANIZATION_ID = :ORG_ID AND WRI.ORGANIZATION_ID (+) = :ORG_ID AND WE.ORGANIZATION_ID (+) = :ORG_ID AND WE.ENTITY_TYPE(+) = 2 AND WL.LINE_ID = WRI.LINE_ID (+) &C_Line_Limiter AND SI.ORGANIZATION_ID(+) = WRI.ORGANIZATION_ID AND WRI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+) AND WRI.PRIMARY_ITEM_ID = SI.INVENTORY_ITEM_ID (+) AND IL.ORGANIZATION_ID (+) = DECODE(WRI.ORGANIZATION_ID,WRI.ORGANIZATION_ID,:ORG_ID) AND WRI.COMPLETION_LOCATOR_ID = IL.INVENTORY_LOCATION_ID (+) AND ML1.LOOKUP_TYPE = 'WIP_LINE_SCHED_TYPE' AND ML1.LOOKUP_CODE = WL.LINE_SCHEDULE_TYPE AND ML2.LOOKUP_TYPE (+) = 'SYS_YES_NO' AND ML2.LOOKUP_CODE (+)= WRI.PRIMARY_LINE_FLAG AND ML3.LOOKUP_TYPE (+) = 'WIP_SUPPLY_SHORT' AND ML3.LOOKUP_CODE (+) = WRI.WIP_SUPPLY_TYPE ORDER BY 1 ASC,3 ASC,4 ASC,5 ASC,6 ASC,7 ASC,8 ASC,2 ASC , WE.WIP_ENTITY_NAME |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Lines From |
|
LOV Oracle | |
To |
|
LOV Oracle |