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 |
