APPS.OKC_QUERY SQL Statements

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

Line: 101

	SELECT
		cimv.OBJECT1_ID1,
		cimv.OBJECT1_ID2,
		cimv.JTOT_OBJECT1_CODE
	FROM OKC_K_ITEMS cimv
	WHERE cimv.CLE_ID = p_cle_id;

Line: 189

           select
		   count(*)
             from okc_k_grpings
            where cgp_parent_id = p_id
		   and included_chr_id is NULL;

Line: 196

           select /*+ FIRST_ROWS */
		   1
             from okc_k_grpings
            where cgp_parent_id = p_id
		   and included_cgp_id is NOT NULL;

Line: 262

select k.contract_number
/*nechatur 18-oct-2005 bug # 4666846  replacing  okc_k_headers_b to okc_k_headers_all_b */
/* from okc_k_headers_b k  */
from okc_k_headers_all_b k
--end bug # 4666846
where k.id = x;

Line: 311

select k.contract_number_modifier
/*nechatur 18-oct-2005 bug # 4666846  replacing  okc_k_headers_b to okc_k_headers_all_b */
/* from okc_k_headers_b k */
from okc_k_headers_all_b k
-- end bug # 4666846
where k.id = x;

Line: 358

	 SELECT fct.function_name
	   FROM okc_classes_b cls,
		   fnd_form_functions fct
       WHERE cls.code = c_code
         AND cls.fff_function_id = fct.function_id;

Line: 400

    SELECT major_version
		 ,minor_version
      FROM okc_k_vers_numbers
     WHERE chr_id = k_id;

Line: 431

           select g.name
             from okc_k_grpings, okc_k_groups_v g
            where included_chr_id = p_contract_id
		    and cgp_parent_id = g.id and
			   ((g.public_YN  = 'Y') or
			    (g.public_YN = 'N' and user_id = FND_GLOBAL.USER_ID));

Line: 488

   SELECT kpr.rle_code, kpr.object1_id1, kpr.object1_id2, kpr.jtot_object1_code
   FROM   okc_k_party_roles_v kpr
   WHERE  dnz_chr_id = p_contract_id
   AND    rle_code   = p_party_role;

Line: 536

SELECT k.contract_number
FROM  okc_resolved_timevalues_v rtv,
      okc_timevalues   tve,
/* nechatur 18-oct-2005 bug # 4666846  replacing  okc_k_headers_b to okc_k_headers_all_b */
     /* okc_k_headers_b  k */
     okc_k_headers_all_b  k
     -- end #4666846
WHERE rtv.tve_id = tve.id
  AND tve.dnz_chr_id = k.id
  AND rtv.id = p_rtv_id;

Line: 575

SELECT cnh_id
FROM   okc_condition_occurs
WHERE  id = p_coe_id;

Line: 580

SELECT acn_id
FROM   okc_condition_headers_b
where  id = l_cnh_id;

Line: 585

SELECT id
FROM   okc_action_attributes_b
WHERE  acn_id = l_acn_id
AND    source_doc_number_yn = 'Y';

Line: 591

SELECT value
FROM   okc_action_att_vals
WHERE  aae_id = l_aae_id
AND    coe_id = p_coe_id;

Line: 659

	 SELECT fct.function_name
	   FROM okc_subclasses_b scls,
                okc_class_operations opr,
	        fnd_form_functions fct
       WHERE scls.code = c_subclass_code
         AND scls.cls_code = opr.cls_code
         AND opr.opn_code = c_operation
         AND opr.detail_function_id = fct.function_id;

Line: 717

	 SELECT fct.function_name
	   FROM okc_class_operations opr,
	        fnd_form_functions fct
       WHERE opr.cls_code = c_cls_code
         AND opr.opn_code = c_operation
         AND opr.detail_function_id = fct.function_id;

Line: 771

  select
    EMAIL_ADDRESS,
    PHONE_COUNTRY_CODE,
    PHONE_AREA_CODE,
    PHONE_NUMBER,
    PHONE_EXTENSION
  from okx_contact_points_v
  where PRIMARY_FLAG = 'Y'
    and owner_table_name = 'HZ_PARTIES'
    and owner_table_id = pid
    and pcode = 'OKX_PCONTACT'
;

Line: 784

  select
    PHONE_COUNTRY_CODE 	FAX_COUNTRY_CODE,
    PHONE_AREA_CODE 	FAX_AREA_CODE,
    PHONE_NUMBER 	FAX_NUMBER,
    PHONE_EXTENSION 	FAX_EXTENSION
  from okx_contact_points_v
  where PHONE_LINE_TYPE = 'FAX'
    and owner_table_name = 'HZ_PARTIES'
    and owner_table_id = pid
    and status = 'A'
;

Line: 854

    l_sql_stmt := 'select ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,LOC.ADDRESS_LINE_1,LOC.ADDRESS_LINE_2,LOC.ADDRESS_LINE_3,'
                || 'NULL,LOC.TOWN_OR_CITY,NULL,NULL,LOC.REGION_1,LOC.POSTAL_CODE,NULL,LOC.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL, NULL,''N'',''N'',200,1,1) ADDRESS '
                || ' from HR_LOCATIONS_ALL LOC, HR_ALL_ORGANIZATION_UNITS OU'
                || ' WHERE OU.ORGANIZATION_ID=:id1 and LOC.LOCATION_ID(+) = OU.LOCATION_ID';

Line: 859

    l_sql_stmt := 'select ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,'
                  ||'CITY,COUNTY,STATE,PROVINCE,POSTAL_CODE,NULL,COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL, NULL,''N'',''N'',200,1,1) ADDRESS from OKX_PARTIES_V WHERE ID1 = :id_1';

Line: 896

		SELECT FROM_TABLE, WHERE_CLAUSE
		FROM JTF_OBJECTS_B
		WHERE OBJECT_CODE = p_object_code;

Line: 912

  l_sql_stmt := 'SELECT EMAIL_ADDRESS FROM ' || l_from_table
			       || ' WHERE ID1 = :id_1 AND ID2 = :id2';

Line: 955

   select EMAIL_ADDRESS
    from okx_contact_points_v
    where owner_table_name = 'HZ_PARTIES'
      and owner_table_id = pid
      and EMAIL_ADDRESS IS NOT NULL
    order by decode(PRIMARY_FLAG,'Y',1,2)
   ;

Line: 991

   select decode(PNT.PHONE_COUNTRY_CODE,NULL,NULL,'+'||PNT.PHONE_COUNTRY_CODE||' ')
        ||decode(PNT.PHONE_AREA_CODE,NULL,NULL,'('||PNT.PHONE_AREA_CODE||')')
        ||PNT.PHONE_NUMBER||decode(PNT.PHONE_EXTENSION,NULL,NULL,'.'||PNT.PHONE_EXTENSION) PHONE
    from okx_contact_points_v PNT
    where owner_table_name = 'HZ_PARTIES'
      and owner_table_id = pid
      and PHONE_NUMBER IS NOT NULL
    order by decode(PRIMARY_FLAG,'Y',1,2)
   ;

Line: 1001

   select WORK_TELEPHONE PHONE
    from OKX_BUYERS_V
    where id1 = pid
   ;