APPS.OZF_QP_QUAL_PVT SQL Statements

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

Line: 68

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 74

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: 81

      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: 143

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 149

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: 156

      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: 168

   g_bg_tbl.delete;

Line: 216

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 221

      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: 233

   g_bg_tbl.DELETE;

Line: 288

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: 294

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 338

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

Line: 344

SELECT party_id
FROM   hz_cust_accounts
WHERE  cust_account_id = p_sold_to_org;

Line: 395

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

Line: 400

  SELECT party_id
    FROM hz_cust_accounts
   WHERE cust_account_id = p_sold_to_org;

Line: 405

  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: 727

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

Line: 732

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

Line: 738

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

Line: 744

  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: 751

  SELECT site_use_code
  FROM   hz_cust_site_uses_all
  WHERE  site_use_id  = p_site_use_id;

Line: 758

  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: 770

  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: 1101

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

Line: 1106

  SELECT party_id
    FROM hz_cust_accounts
   WHERE cust_account_id = p_sold_to_org;

Line: 1111

  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: 1433

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

Line: 1438

  SELECT party_id
    FROM hz_cust_accounts
   WHERE cust_account_id = p_sold_to_org;

Line: 1443

  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: 1455

  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: 1905

   SELECT line.inventory_item_id, line.org_id,
               line.order_quantity_uom, head.transactional_curr_code,
               head.conversion_type_code, line.ship_from_org_id
    FROM oe_order_lines_all line, oe_order_headers_all head
    WHERE line.line_id = p_order_line_id
    AND line.header_id = head.header_id;

Line: 1913

   SELECT inventory_item_id,org_id, supplier_item_cost,
               nvl(supplier_item_uom,uom_code), currency_code
   FROM ozf_resale_lines_all
   WHERE resale_line_id = p_resale_line_id;

Line: 1919

   SELECT inventory_item_id,org_id, supplier_item_cost,
                nvl(supplier_item_uom,uom_code), currency_code
   FROM ozf_resale_lines_int_all
   WHERE resale_line_int_id = p_resale_line_int_id;

Line: 1925

   SELECT orb.direct_order_flag
   FROM ozf_resale_lines_int_all orli, ozf_resale_batches_all orb
   WHERE orli.resale_line_int_id = p_resale_line_int_id
   AND orb.resale_batch_id = orli.resale_batch_id;

Line: 1931

   SELECT orb.direct_order_flag
   FROM  ozf_resale_batches_all orb,
             ozf_resale_batch_line_maps_all orblm
   WHERE orblm.resale_line_id = p_resale_line_id
   AND orblm.resale_batch_id = orb.resale_batch_id;

Line: 1938

  SELECT exchange_rate_type
  FROM ozf_sys_parameters_all
  WHERE org_id=p_org_id;

Line: 1943

  SELECT primary_uom_code
  FROM mtl_system_items
  WHERE inventory_item_id = p_inventory_item_id
  AND organization_id = p_inv_org_id;

Line: 1950

  SELECT ogs.currency_code
  FROM   org_organization_definitions ood, oe_gl_sets_of_books_v ogs
  WHERE  ood.organization_id =  p_organization_id
  AND  ood.set_of_books_id = ogs.set_of_books_id;

Line: 1989

        l_qry_str := 'UPDATE ozf_resale_lines_all SET supplier_item_cost = :1 WHERE resale_line_id = :2 AND supplier_item_cost IS NULL' ;

Line: 2031

        l_qry_str := 'UPDATE ozf_resale_lines_int_all SET supplier_item_cost = :1 WHERE resale_line_int_id = :2 AND supplier_item_cost IS NULL';

Line: 2091

                 l_qry_str := 'UPDATE oe_order_lines_all SET '|| l_column_name ||'  = :1 WHERE line_id = :2 AND ' || l_column_name ||' IS NULL';

Line: 2250

   SELECT qualifier_attr_value
    FROM qp_qualifiers
    WHERE list_header_id=p_list_header_id
    AND qualifier_context = p_qualifier_context
    AND qualifier_attribute = p_qualifier_attribute;

Line: 2257

   SELECT attribute3
    FROM oe_order_lines_all
    WHERE line_id = p_order_line_id;

Line: 2262

   SELECT line.attribute4
   FROM oe_order_lines_all line, mtl_system_items item
   WHERE line.line_id = p_order_line_id
   AND line.inventory_item_id = item.inventory_item_id;