DBA Data[Home] [Help]

APPS.FUN_TRADING_RELATION dependencies on FUN_SUPPLIER_MAPS

Line 90: fun_supplier_maps supp

86: p_trans_organization_id NUMBER,
87: p_tp_organization_id NUMBER ) IS
88: SELECT rel.relation_id
89: FROM FUN_TRADE_RELATIONS rel,
90: fun_supplier_maps supp
91: WHERE Nvl(rel.source,'INTERCOMPANY') = p_source
92: AND rel.transaction_le_id = p_trans_le_id
93: AND rel.tp_le_id = p_tp_le_id
94: AND nvl(rel.transaction_org_id , -1) = nvl(p_trans_org_id, -1)

Line 325: FROM fun_supplier_maps rel,

321:
322: CURSOR c_vendor_info (x_relation_id NUMBER,
323: p_trx_date DATE) IS
324: SELECT rel.vendor_id, rel.vendor_site_id
325: FROM fun_supplier_maps rel,
326: ap_suppliers supp,
327: ap_supplier_sites_all site
328: WHERE relation_id = x_relation_id
329: AND supp.vendor_id = rel.vendor_id