WIP Production Line

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: Production Line Report (XML)
Short Name: WIPSULIN_XML
DB package: WIP_WIPSULIN_XMLP_PKG
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
Quantity_precision
 
Number
Org Id
 
Number
To
 
LOV Oracle
Lines From
 
LOV Oracle