DBA Data[Home] [Help]

APPS.FUN_TRADING_RELATION dependencies on FUN_CUSTOMER_MAPS

Line 71: fun_customer_maps cust

67: p_trans_organization_id NUMBER,
68: p_tp_organization_id NUMBER ) IS
69: SELECT rel.relation_id
70: FROM FUN_TRADE_RELATIONS rel,
71: fun_customer_maps cust
72: WHERE Nvl(rel.source,'INTERCOMPANY') = p_source
73: AND rel.transaction_le_id = p_trans_le_id
74: AND rel.tp_le_id = p_tp_le_id
75: AND nvl(rel.transaction_org_id , -1) = nvl(p_trans_org_id, -1)

Line 163: FROM fun_customer_maps mp,

159: CURSOR c_cust_acct(x_relation_id NUMBER ) IS
160: SELECT mp.cust_account_id ,
161: mp.site_use_id,
162: site.cust_acct_site_id
163: FROM fun_customer_maps mp,
164: hz_cust_acct_sites_all site,
165: hz_cust_site_uses_all use
166: WHERE relation_id = x_relation_id
167: AND site.cust_account_id = mp.cust_account_id