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 4150: * value of inv_currency_code column in the mtl_intercompany_parameters

4146: end;*/
4147:
4148: /* Added this for bug 3141793
4149: * The currency code in which the transfer price will be return is control by the
4150: * value of inv_currency_code column in the mtl_intercompany_parameters
4151: * The possible value of inv_currency_code are:
4152: * 1 - Currency of the SHip/From/Procuring OU
4153: * 2 - Currency of the Sell/To/Receiving OU
4154: * 3 - Order Currency (Sales Order/Purchase Order)

Line 4168: From mtl_intercompany_parameters

4164: /* Bug 4903269 moved the call in order to get the option of currency of sales order to work */
4165: BEGIN
4166: select nvl(inv_currency_code, 1)
4167: into l_inv_currency_code
4168: From mtl_intercompany_parameters
4169: where ship_organization_id = p_from_org_id
4170: and sell_organization_id = p_to_org_id
4171: and flow_type = l_flow_type;
4172: EXCEPTION

Line 4667: FROM mtl_intercompany_parameters

4663:
4664: BEGIN
4665: select 1
4666: into l_exists
4667: FROM mtl_intercompany_parameters
4668: where sell_organization_id = p_to_org_id
4669: AND ship_organization_id = p_from_org_id
4670: and flow_type = l_flow_type;
4671: EXCEPTION

Line 4721: FROM mtl_intercompany_parameters MIP

4717: /* Modified query below : RA to HZ conversions
4718: Replaced occurances of RA views with HZ tables*/
4719: /* SELECT nvl(RSU.price_list_id, nvl(RC.price_list_id, -1)), RSU.location, RC.Customer_number, RC.Customer_name
4720: INTO l_price_List_Id, l_location, l_customer_number, l_customer_name
4721: FROM mtl_intercompany_parameters MIP
4722: , ra_site_uses_all RSU
4723: , ra_customers RC
4724: WHERE MIP.sell_organization_id = p_to_org_id
4725: AND MIP.ship_organization_id = p_from_org_id

Line 4737: FROM mtl_intercompany_parameters mip

4733: , rsu.LOCATION
4734: , rc.customer_number
4735: , rc.customer_name
4736: INTO l_price_List_Id, l_location, l_customer_number, l_customer_name
4737: FROM mtl_intercompany_parameters mip
4738: , hz_cust_site_uses_all rsu
4739: , (SELECT cust_account_id customer_id
4740: , party.party_name customer_name
4741: , party.party_number customer_number