INV Inter-organization shipping information listing

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Inter-organization shipping information listing (XML)
Short Name: INVSRIOS_XML
DB package: INV_INVSRIOS_XMLP_PKG
select  o.organization_name 		from_org,
            o.chart_of_accounts_id                    acct_struct_num,
	lu1.meaning		intransit_status,
	i.to_organization_distance 	distance,
	i.distance_uom_code		uom,
	lu2.meaning		 	transfer_code,
	lu3.meaning			fob_point,
	rcv.routing_name 	primary_rcv_routing_type,
	lu4.meaning		internal_order_required,
	i.interorg_trnsfr_charge_percent charge_percent,
	&P_inv_acct_flex		C_inv_acct_flex_f,
	&P_trf_acct_flex		C_trf_acct_flex_f,
	&P_rcv_acct_flex		C_rcv_acct_flex_f,
	&P_pay_acct_flex		C_pay_acct_flex_f,
	&P_pva_acct_flex		C_pva_acct_flex_f,
	inv.code_combination_id	inv_acct_id,
	trf.code_combination_id 	trf_acct_id,
	rcv.code_combination_id 	rcv_acct_id,
	pay.code_combination_id 	pay_acct_id,
	pva.code_combination_id 	pva_acct_id
	,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_inv_acct_field_f', 'SQLGL', 'GL#', INV.CHART_OF_ACCOUNTS_ID, NULL, INV.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_inv_acct_field_f
	,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_trf_acct_field_f', 'SQLGL', 'GL#', TRF.CHART_OF_ACCOUNTS_ID, NULL, TRF.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_trf_acct_field_f
	,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_rcv_acct_field_f', 'SQLGL', 'GL#', RCV.CHART_OF_ACCOUNTS_ID, NULL, RCV.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_rcv_acct_field_f
	,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pay_acct_field_f', 'SQLGL', 'GL#', PAY.CHART_OF_ACCOUNTS_ID, NULL, PAY.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_pay_acct_field_f
	,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pva_acct_field_f', 'SQLGL', 'GL#', PVA.CHART_OF_ACCOUNTS_ID, NULL, PVA.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_pva_acct_field_f
from	mtl_interorg_parameters		i,
	rcv_routing_headers	rcv,
	mfg_lookups			lu1,
	mfg_lookups			lu2,
	mfg_lookups			lu3,
	mfg_lookups			lu4,
	org_organization_definitions	o,
	gl_code_combinations		inv,
	gl_code_combinations		trf,
	gl_code_combinations		rcv,
	gl_code_combinations		pay,
	gl_code_combinations		pva
where       i.to_organization_id =  :P_org_id
and           i.routing_header_id  = rcv.routing_header_id(+)
and	i.intransit_type = lu1.lookup_code(+)
and	lu1.lookup_type(+) = 'ORG_INTRANSIT'
and	i.matl_interorg_transfer_code = lu2.lookup_code(+)
and	lu2.lookup_type(+) = 'MTL_INTER_INV_TRANSFER'
and	i.fob_point = lu3.lookup_code(+)
and	lu3.lookup_type(+) = 'MTL_FOB_POINT'
and 	i.internal_order_required_flag = lu4.lookup_code(+)
and	lu4.lookup_type(+) = 'SYS_YES_NO'
and	i.INTRANSIT_INV_ACCOUNT = inv.code_combination_id(+)
and	i.INTERORG_TRANSFER_CR_ACCOUNT = trf.code_combination_id(+)
and	i.INTERORG_RECEIVABLES_ACCOUNT = rcv.code_combination_id(+)
and	i.INTERORG_PAYABLES_ACCOUNT = pay.code_combination_id(+)
and	i.INTERORG_PRICE_VAR_ACCOUNT = pva.code_combination_id(+)
and	o.organization_id = i.from_organization_id
and 	o.organization_id <> :P_org_id
&C_org_where
order by 1
Parameter Name SQL text Validation
Organization
 
Number
From/To Organization
 
LOV Oracle
Ask a question