WIP Job Lot Composition
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Job Lot Composition Report
Application: Work in Process
Source: Job Lot Composition Report (XML)
Short Name: WIPMTDLT_XML
DB package: WIP_WIPMTDLT_XMLP_PKG
Description: Job Lot Composition Report
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 | |
---|---|---|---|
Sort By |
|
LOV Oracle | |
Assembly |
|
Char | |
Dates From |
|
Date | |
To |
|
Date | |
Jobs From |
|
LOV Oracle | |
To 2 |
|
LOV Oracle | |
Lots From |
|
LOV Oracle | |
To 3 |
|
LOV Oracle |