select
mp.organization_code,
wmt.transaction_date,
we.wip_entity_name job,
xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) job_type,
wl.line_code line,
msiv.concatenated_segments assembly,
msiv.description assembly_description,
wmt.fm_operation_seq_num from_operation_seq,
wmt.fm_operation_code from_operation_code,
bd_fm.department_code from_department,
xxen_util.meaning(wmt.fm_intraoperation_step_type,'WIP_INTRAOPERATION_STEP',700) from_step,
wmt.to_operation_seq_num to_operation_seq,
wmt.to_operation_code,
bd_to.department_code to_department,
xxen_util.meaning(wmt.to_intraoperation_step_type,'WIP_INTRAOPERATION_STEP',700) to_step,
wmt.transaction_quantity quantity,
wmt.transaction_uom uom,
wmt.primary_quantity,
wmt.primary_uom,
wmt.overcompletion_transaction_qty overcompletion_quantity,
wmt.overcompletion_primary_qty,
xxen_util.concatenated_segments(wmt.scrap_account_id) scrap_account,
mtr.reason_name reason,
wmt.reference,
wmt.source_code,
xxen_util.user_name(wmt.created_by) created_by,
wmt.creation_date,
wmt.transaction_id
from
mtl_parameters mp,
wip_move_transactions wmt,
wip_entities we,
wip_lines wl,
mtl_system_items_vl msiv,
bom_departments bd_fm,
bom_departments bd_to,
mtl_transaction_reasons mtr
where
1=1 and
mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
mp.organization_id=wmt.organization_id and
wmt.wip_entity_id=we.wip_entity_id and
wmt.line_id=wl.line_id(+) and
wmt.organization_id=wl.organization_id(+) and
wmt.organization_id=msiv.organization_id(+) and
wmt.primary_item_id=msiv.inventory_item_id(+) and
wmt.fm_department_id=bd_fm.department_id and
wmt.to_department_id=bd_to.department_id and
wmt.reason_id=mtr.reason_id(+)
order by
mp.organization_code,
wmt.transaction_date,
wmt.transaction_id |
