WIP Mass Return Components for Serialized Assembly
Description
Categories: BI Publisher
Application: Work in Process
Source: Mass Return Components for Serialized Assembly Report
Short Name: WIPDEKIT_XML
DB package: WIP_WIPDEKIT_XMLP_PKG
Source: Mass Return Components for Serialized Assembly Report
Short Name: WIPDEKIT_XML
DB package: WIP_WIPDEKIT_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 mp.organization_code, wtr.program_source, wtr.last_updated_by, msik.concatenated_segments item_name, we.wip_entity_name job_name, wtr.attribute1 parent_serial, wtr.attribute2 component_serial, wtr.attribute3 lot_number, wtr.attribute4 revision, wtr.attribute5 error_explanation, wtr.attribute6 subinventory, milk.concatenated_segments locator, wtr.key1 request_id, wtr.key2 quantity, wtr.key3 op_seq_num, wtr.key4 process_flag, wtr.key5 transaction_id, wtr.date1 creation_date, msik.description description from wip_temp_reports wtr, wip_entities we, mtl_system_items_kfv msik, mtl_parameters mp, mtl_item_locations_kfv milk where wtr.program_source = 'WIPDEKIT' and we.wip_entity_id = wtr.wip_entity_id and we.organization_id = wtr.organization_id and msik.inventory_item_id = wtr.inventory_item_id and msik.organization_id = wtr.organization_id and mp.organization_id = wtr.organization_id and wtr.organization_id = milk.organization_id (+) and wtr.key6 = milk.inventory_location_id (+) and wtr.organization_id = :P_ORG_ID and wtr.wip_entity_id = :P_WIP_ENTITY_ID and wtr.attribute1 = :P_SERIAL_NUM and wtr.key1 = :P_CONC_REQUEST_ID and wtr.key4 = 3 order by item_name |