ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B5C67DC8874306C4E053B46B63588B80Y 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 US INV Intercompany Transaction Flows Inventory Intercompany Transaction Flows Setup