APPS.INV_TRANSACTION_FLOW_PUB dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 145: mtl_intercompany_parameters icp

141: icp.expense_accrual_account_id,
142: icp.intercompany_cogs_account_id
143: FROM
144: mtl_transaction_flow_lines t_line,
145: mtl_intercompany_parameters icp
146: WHERE
147: t_line.header_id = l_header_id
148: and icp.ship_organization_id=t_line.from_org_id
149: and icp.sell_organization_id=t_line.to_org_id

Line 492: mtl_intercompany_parameters icp

488: icp.intercompany_cogs_account_id
489: FROM
490: mtl_transaction_flow_headers t_hdr,
491: mtl_transaction_flow_lines t_line,
492: mtl_intercompany_parameters icp
493: WHERE
494: t_hdr.header_id = l_header_id
495: AND t_hdr.header_id = t_line.header_id (+)
496: and icp.ship_organization_id=t_line.from_org_id

Line 1096: FROM MTL_INTERCOMPANY_PARAMETERS

1092: vDummy VARCHAR2(30);
1093: BEGIN
1094:
1095: SELECT 'ic_relation_exists' INTO vDummy
1096: FROM MTL_INTERCOMPANY_PARAMETERS
1097: WHERE ship_organization_id = p_from_org_id_tbl(i)
1098: AND sell_organization_id = p_to_org_id_tbl(i)
1099: AND flow_type = p_flow_type;
1100:

Line 1937: mtl_intercompany_parameters

1933: intercompany_cogs_account_id,
1934: inventory_accrual_account_id,
1935: expense_accrual_account_id
1936: FROM
1937: mtl_intercompany_parameters
1938: WHERE
1939: ship_organization_id = l_ship_organization_id
1940: AND sell_organization_id = l_sell_organization_id
1941: AND flow_type = l_flow_type;

Line 2778: ELSIF NOT inv_transaction_flow_pvt.Validate_Dff( P_FLEX_NAME => 'MTL_INTERCOMPANY_PARAMETERS',

2774:
2775: IF p_attribute_category = g_miss_num THEN
2776: --Do nothing
2777: NULL;
2778: ELSIF NOT inv_transaction_flow_pvt.Validate_Dff( P_FLEX_NAME => 'MTL_INTERCOMPANY_PARAMETERS',
2779: P_ATTRIBUTE1 => p_attribute1,
2780: P_ATTRIBUTE2 => p_attribute2,
2781: P_ATTRIBUTE3 => p_attribute3,
2782: P_ATTRIBUTE4 => p_attribute4,

Line 4068: * value of inv_currency_code column in the mtl_intercompany_parameters

4064: end;*/
4065:
4066: /* Added this for bug 3141793
4067: * The currency code in which the transfer price will be return is control by the
4068: * value of inv_currency_code column in the mtl_intercompany_parameters
4069: * The possible value of inv_currency_code are:
4070: * 1 - Currency of the SHip/From/Procuring OU
4071: * 2 - Currency of the Sell/To/Receiving OU
4072: * 3 - Order Currency (Sales Order/Purchase Order)

Line 4086: From mtl_intercompany_parameters

4082: /* Bug 4903269 moved the call in order to get the option of currency of sales order to work */
4083: BEGIN
4084: select nvl(inv_currency_code, 1)
4085: into l_inv_currency_code
4086: From mtl_intercompany_parameters
4087: where ship_organization_id = p_from_org_id
4088: and sell_organization_id = p_to_org_id
4089: and flow_type = l_flow_type;
4090: EXCEPTION

Line 4498: FROM mtl_intercompany_parameters

4494:
4495: BEGIN
4496: select 1
4497: into l_exists
4498: FROM mtl_intercompany_parameters
4499: where sell_organization_id = p_to_org_id
4500: AND ship_organization_id = p_from_org_id
4501: and flow_type = l_flow_type;
4502: EXCEPTION

Line 4552: FROM mtl_intercompany_parameters MIP

4548: /* Modified query below : RA to HZ conversions
4549: Replaced occurances of RA views with HZ tables*/
4550: /* SELECT nvl(RSU.price_list_id, nvl(RC.price_list_id, -1)), RSU.location, RC.Customer_number, RC.Customer_name
4551: INTO l_price_List_Id, l_location, l_customer_number, l_customer_name
4552: FROM mtl_intercompany_parameters MIP
4553: , ra_site_uses_all RSU
4554: , ra_customers RC
4555: WHERE MIP.sell_organization_id = p_to_org_id
4556: AND MIP.ship_organization_id = p_from_org_id

Line 4568: FROM mtl_intercompany_parameters mip

4564: , rsu.LOCATION
4565: , rc.customer_number
4566: , rc.customer_name
4567: INTO l_price_List_Id, l_location, l_customer_number, l_customer_name
4568: FROM mtl_intercompany_parameters mip
4569: , hz_cust_site_uses_all rsu
4570: , (SELECT cust_account_id customer_id
4571: , party.party_name customer_name
4572: , party.party_number customer_number