APPS.OZF_QP_QUAL_PVT SQL Statements

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

Line: 65

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 71

select object_id
from hz_party_relationships
where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
and subject_id=p_party_id;

Line: 78

      SELECT r1.object_id
      FROM   hz_relationships r1
      WHERE  r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
      AND    r1.subject_type = 'ORGANIZATION'
      AND    r1.subject_table_name = 'HZ_PARTIES'
      AND    r1.object_type = 'ORGANIZATION'
      AND    r1.object_table_name = 'HZ_PARTIES'
      AND    r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
      AND    r1.status = 'A'
      AND    r1.subject_id=p_party_id;

Line: 140

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 146

select object_id
from hz_party_relationships
where party_relationship_type = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
and subject_id=p_party_id;

Line: 153

      SELECT r1.object_id
      FROM   hz_relationships r1
      WHERE  r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
      AND    r1.subject_type = 'ORGANIZATION'
      AND    r1.subject_table_name = 'HZ_PARTIES'
      AND    r1.object_type = 'ORGANIZATION'
      AND    r1.object_table_name = 'HZ_PARTIES'
      AND    r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
      AND    r1.status = 'A'
      AND    r1.subject_id=p_party_id;

Line: 165

   g_bg_tbl.delete;

Line: 213

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 218

      SELECT r1.object_id
      FROM   hz_relationships r1
      WHERE  r1.relationship_code = g_rel_type --FND_PROFILE.value ('OZF_PARTY_RELATIONS_TYPE')
      AND    r1.subject_type = 'ORGANIZATION'
      AND    r1.subject_table_name = 'HZ_PARTIES'
      AND    r1.object_type = 'ORGANIZATION'
      AND    r1.object_table_name = 'HZ_PARTIES'
      AND    r1.start_date <= SYSDATE AND NVL(r1.end_date, SYSDATE) >= SYSDATE
      AND    r1.status = 'A'
      AND    r1.subject_id=p_party_id;

Line: 230

   g_bg_tbl.DELETE;

Line: 285

SELECT  pms.market_segment_id
FROM    ams_party_market_segments pms
WHERE   pms.party_id = p_party_id
AND     pms.market_qualifier_type IS NULL;

Line: 291

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 335

SELECT list_header_id
  FROM ams_list_entries
 WHERE enabled_flag = 'Y'
   AND party_id = p_party_id;

Line: 341

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 392

  SELECT city,postal_code,state,county,country,party_id
    FROM hz_parties
   WHERE party_id = p_party_id;

Line: 397

  SELECT party_id
    FROM hz_cust_accounts
   WHERE cust_account_id = p_sold_to_org;

Line: 402

  SELECT /*+ ORDERED */ -- julou sql performance fix
         count(*)
    FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu, jtf_qual_type_usgs jqtu
   WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
         ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
         jt.end_date_active IS NULL ))
     AND jt.terr_id = jtqu.terr_id
     AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
     AND jqtu.source_id = -1003
     AND jqtu.qual_type_id = -1007;

Line: 724

  SELECT city,postal_code,state,county,country,party_id,province,category_code
    FROM hz_parties
   WHERE party_id = p_party_id;

Line: 729

  SELECT party_id
    FROM hz_cust_accounts
   WHERE cust_account_id = p_sold_to_org
   AND   status = 'A';

Line: 735

  SELECT sales_channel_code
  FROM   hz_cust_accounts
  WHERE  cust_account_id = p_cust_acct_id
  and    status = 'A';

Line: 741

  SELECT profile_class_id
  FROM   hz_customer_profiles
  WHERE  cust_account_id = p_sold_to
  AND    status = 'A'
  AND    site_use_id IN (p_ship_to, p_bill_to);

Line: 748

  SELECT site_use_code
  FROM   hz_cust_site_uses_all
  WHERE  site_use_id  = p_site_use_id;

Line: 755

  SELECT /*+ ORDERED */ -- julou sql performance fix
         count(*)
    FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu, jtf_qual_type_usgs jqtu
   WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
         ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
         jt.end_date_active IS NULL ))
     AND jt.terr_id = jtqu.terr_id
     AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
     AND jqtu.source_id = -1003
     AND jqtu.qual_type_id = -1007;

Line: 767

  SELECT hzcasa.party_site_id
  FROM   hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa
  WHERE  hzcasa.cust_acct_site_id = hzcsua.cust_acct_site_id
  AND    hzcsua.site_use_id = p_ship_to_org_id;

Line: 1098

  SELECT city,postal_code,state,county,country,party_id
    FROM hz_parties
   WHERE party_id = p_party_id;

Line: 1103

  SELECT party_id
    FROM hz_cust_accounts
   WHERE cust_account_id = p_sold_to_org;

Line: 1108

  SELECT /*+ ORDERED */ -- julou sql performance fix
         count(*)
    FROM jtf_terr_all jt, jtf_terr_qtype_usgs_all jtqu,jtf_qual_type_usgs jqtu
   WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
         ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
         jt.end_date_active IS NULL ))
     AND jt.terr_id = jtqu.terr_id
     AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
     AND jqtu.source_id = -1001
     AND jqtu.qual_type_id = -1002;

Line: 1430

  SELECT city,postal_code,state,county,country,party_id
    FROM hz_parties
   WHERE party_id = p_party_id;

Line: 1435

  SELECT party_id
    FROM hz_cust_accounts
   WHERE cust_account_id = p_sold_to_org;

Line: 1440

  SELECT /*+ ORDERED */ -- julou sql performance fix
         count(*)
    FROM jtf_terr jt, jtf_terr_qtype_usgs jtqu,jtf_qual_type_usgs jqtu
   WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE) AND
         ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR
         jt.end_date_active IS NULL ))
     AND jt.terr_id = jtqu.terr_id
     AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
     AND jqtu.source_id = -1001
     AND jqtu.qual_type_id = -1002;

Line: 1452

  SELECT hzcasa.party_site_id
  FROM   hz_cust_site_uses_all hzcsua, hz_cust_acct_sites_all hzcasa
  WHERE  hzcasa.cust_acct_site_id = hzcsua.cust_acct_site_id
  AND    hzcsua.site_use_id = p_ship_to_org_id;