WIP Job Lot Composition

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: Job Lot Composition Report (XML)
Short Name: WIPMTDLT_XML
DB package: WIP_WIPMTDLT_XMLP_PKG
select &P_ASSY_FLEX C_ASSY_FLEX,
       MSI.description,
       WE.wip_entity_name Job,
       DJ.lot_number Lot,
       round(DJ.start_quantity,:P_Qty_Precision) Qty_Planned,
       DJ.date_released Release_Date,
       ML.meaning Status,
       round(DJ.quantity_completed,:P_Qty_Precision) Qty_Completed,
       DJ.date_completed Complete_Date,
       MSI.primary_uom_code UOM,
       DJ.bom_revision Revision,
       DJ.wip_entity_id,
       WE.primary_item_id, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly1', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Assembly1
from wip_entities WE,
     mfg_lookups ML,
     mtl_system_items MSI,
     wip_discrete_jobs DJ
where 
  exists (select 1 from MTL_TRANSACTION_LOT_NUMBERS MTV
          where MTV.TRANSACTION_SOURCE_TYPE_ID =5 
          and MTV.TRANSACTION_SOURCE_ID = DJ. wip_entity_id 
          and MTV.organization_id = :P_Organization_Id
          and rownum =1)
  and WE.organization_id = :P_Organization_Id
  and DJ.organization_id = :P_Organization_Id
  and MSI.organization_id &P_OUTER = :P_Organization_Id
  and DJ.status_type = ML.lookup_code
  and ML.lookup_type = 'WIP_JOB_STATUS'
  and DJ.wip_entity_id = WE.wip_entity_id
  and DJ.primary_item_id = MSI.inventory_item_id &P_OUTER
  &Limit_Dates
  &Limit_Jobs
  &Limit_Lots
  --&Limit_Assembly
  and &P_FLEXWHERE
&Sort_Option
Parameter Name SQL text Validation
Quanitity Precision
 
Number
Org Id
 
Number
Flex structure number
 
Number
To
 
LOV Oracle
Lots From
 
LOV Oracle
To
 
LOV Oracle
Jobs From
 
LOV Oracle
To
 
Date
Dates From
 
Date
Assembly
 
Sort By
 
LOV Oracle
Ask a question