WIP Job Lot Composition

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