APPS.FUN_TRADING_RELATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

SELECT 1
        FROM FND_LOOKUP_VALUES
        WHERE lookup_type = 'FUN_TRADE_REL_SOURCE'
        AND   language    = USERENV('LANG')
        AND lookup_code = p_source;

Line: 69

      SELECT rel.relation_id
      FROM FUN_TRADE_RELATIONS rel,
           fun_customer_maps   cust
      WHERE Nvl(rel.source,'INTERCOMPANY') = p_source
      AND rel.transaction_le_id = p_trans_le_id
      AND rel.tp_le_id = p_tp_le_id
      AND nvl(rel.transaction_org_id , -1) = nvl(p_trans_org_id, -1)
      AND nvl(rel.tp_org_id,-1) = nvl(p_tp_org_id,-1)
      AND rel.transaction_organization_id=p_trans_organization_id
      AND rel.tp_organization_id=p_tp_organization_id
      AND rel.relation_id = cust.relation_id;

Line: 88

      SELECT rel.relation_id
      FROM FUN_TRADE_RELATIONS rel,
           fun_supplier_maps   supp
      WHERE Nvl(rel.source,'INTERCOMPANY') = p_source
      AND rel.transaction_le_id = p_trans_le_id
      AND rel.tp_le_id = p_tp_le_id
      AND nvl(rel.transaction_org_id , -1) = nvl(p_trans_org_id, -1)
      AND nvl(rel.tp_org_id,-1) = nvl(p_tp_org_id,-1)
      AND rel.transaction_organization_id=p_trans_organization_id
      AND rel.tp_organization_id=p_tp_organization_id
      AND rel.relation_id = supp.relation_id;

Line: 160

     SELECT mp.cust_account_id ,
            mp.site_use_id,
            site.cust_acct_site_id
     FROM fun_customer_maps mp,
          hz_cust_acct_sites_all site,
          hz_cust_site_uses_all  use
     WHERE relation_id = x_relation_id
     AND   site.cust_account_id   = mp.cust_account_id
     AND   site.cust_acct_site_id = use.cust_acct_site_id
     AND   use.site_use_id        = mp.site_use_id
     AND   use.status = 'A'
     AND   site.status = 'A';

Line: 174

     SELECT site_use_id , cust_acct_site_id
     FROM hz_cust_site_uses_all
     WHERE cust_acct_site_id
     IN ( SELECT cust_acct_site_id FROM hz_cust_acct_sites_all WHERE cust_account_id = x_cust_acct_id AND org_id = p_trans_org_id)
     AND org_id = p_trans_org_id
     AND site_use_code = 'BILL_TO'
     AND status = 'A'
     AND primary_flag = 'Y';

Line: 184

     SELECT party_id
     FROM hz_cust_accounts_all
     WHERE cust_account_id = x_cust_acct_id
     AND   status = 'A';

Line: 324

    SELECT rel.vendor_id,  rel.vendor_site_id
    FROM fun_supplier_maps rel,
         ap_suppliers supp,
          ap_supplier_sites_all site
    WHERE relation_id = x_relation_id
    AND   supp.vendor_id = rel.vendor_id
    AND   site.vendor_site_id = rel.vendor_site_id
    AND   supp.vendor_id = site.vendor_id
    AND   p_trx_date BETWEEN Nvl(TRUNC(supp.start_date_active), p_trx_date) AND Nvl(TRUNC(supp.end_date_active), p_trx_date)
    AND   Nvl(TRUNC(site.inactive_date), p_trx_date) >= p_trx_date;

Line: 337

    SELECT vendor_site_id
    FROM po_vendor_sites_all
    WHERE vendor_id = x_vendor_id AND (pay_site_flag = 'Y'  or  primary_pay_site_flag = 'Y' )
    AND org_id = p_trans_org_id ;