INV Intercompany Transaction Flows

select
 mtfhv.start_org_name
,mtfhv.end_org_name
,mtfhv.organization_code
,(select flvv.meaning
  from   fnd_lookup_values_vl flvv
  where  flvv.lookup_type = 'INV_TRANSACTION_FLOW_TYPE'
  and    flvv.lookup_code = mtfhv.flow_type
 ) flow_type_d
,mtfhv.start_date
,mtfhv.end_date
,mtfhv.qualifier_code
,mtfhv.qualifier_value_id
,mtfhv.qualifier_value_code
,mtfhv.asset_item_pricing_option
,mtfhv.expense_item_pricing_option
,mtfhv.new_accounting_flag
,mtflv.line_number
,mtflv.from_org_name
,mtflv.to_org_name
,mtflv.from_organization_code
,mtflv.to_organization_code
,(select flvv.meaning
  from   fnd_lookup_values_vl flvv
  where  flvv.lookup_type = 'INV_TRANSACTION_FLOW_TYPE'
  and    flvv.lookup_code = mipv.flow_type
 ) ic_flow_type_d
, mipv.supplier_name
, mipv.vendor_site
, mipv.customer_name
, mipv.customer_number
, mipv.location
, mipv.transaction_name
,'**'
, mtfhv.start_org_id
, mtfhv.end_org_id
, mtfhv.organization_id
, mtfhv.flow_type flow_type
, mipv.flow_type   ic_flow_type
, mtflv.from_org_id
, mtflv.to_org_id
, mtflv.from_organization_id
, mtflv.to_organization_id
, mipv.vendor_id
, mipv.vendor_site_id
, mipv.customer_id
, mipv.address_id
, mipv.customer_site_id
, mipv.cust_trx_type_id
from
  mtl_transaction_flow_headers_v mtfhv
, mtl_transaction_flow_lines_v   mtflv
, mtl_intercompany_parameters_v  mipv
where
     mtfhv.header_id    = mtflv.header_id
and  mtflv.from_org_id  = mipv.ship_organization_id (+)
and  mtflv.to_org_id    = mipv.sell_organization_id (+)
order by
 mtfhv.start_org_name
,mtfhv.end_org_name
,mtfhv.organization_code
,mtflv.line_number