APPS.CSC_SERVICE_KEY_PVT SQL Statements

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

Line: 29

	SELECT incident_id, customer_id, customer_phone_id, customer_email_id,
	       account_id
   	FROM cs_incidents_all_b
	WHERE incident_number = l_skey_value;

Line: 36

  	SELECT party_id, contact_point_id, contact_point_type, contact_type
 	FROM cs_hz_sr_contact_points
	WHERE primary_flag = 'Y' AND
	      --contact_type <> 'EMPLOYEE' AND
	      incident_id = l_incident_id;

Line: 44

	SELECT contact_point_id, contact_point_type
	FROM cs_hz_sr_contact_points
	WHERE incident_id = l_incident_id AND
	      party_id = l_party_id AND
	      contact_point_type = l_contact_point_type AND
	      rownum < 2;

Line: 53

	SELECT subject_id
	FROM hz_relationships
	WHERE party_id = l_party_id AND
	      subject_type = 'PERSON' AND
              object_id = l_object_id;

Line: 61

	SELECT cust_acct.party_id, cust_acct.cust_account_id, customer_trx_id, ra.org_id org_id
	FROM hz_cust_accounts cust_acct, ra_customer_trx_all ra
	WHERE cust_acct.cust_account_id = ra.bill_to_customer_id AND
	      ra.complete_flag = 'Y' AND
	      ra.cust_trx_type_id IN
			( SELECT cust_trx_type_id FROM ra_cust_trx_types_all
			  WHERE type = 'INV') AND
	      ra.trx_number = l_skey_value;

Line: 72

	SELECT cust_acct.party_id, cust_acct.cust_account_id, customer_trx_id, ra.org_id org_id
	FROM hz_cust_accounts cust_acct, ra_customer_trx ra
	WHERE cust_acct.cust_account_id = ra.bill_to_customer_id AND
	      ra.complete_flag = 'Y' AND
	      ra.cust_trx_type_id IN
			( SELECT cust_trx_type_id FROM ra_cust_trx_types
			  WHERE type = 'INV') AND
	      ra.trx_number = l_skey_value;

Line: 83

	SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
	FROM oe_order_headers_all oe, hz_cust_accounts hza
	WHERE oe.sold_to_org_id = hza.cust_account_id AND
	      oe.order_number = l_skey_value;

Line: 89

        SELECT party_id
        FROM hz_cust_account_roles
        WHERE cust_account_role_id = l_sold_to_contact_id;

Line: 96

	SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
	FROM oe_order_headers oe, hz_cust_accounts hza
	WHERE oe.sold_to_org_id = hza.cust_account_id AND
	      oe.order_number = l_skey_value;

Line: 103

	SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
	FROM oe_order_headers_all oe, hz_cust_accounts hza
	WHERE oe.sold_to_org_id = hza.cust_account_id AND
-- Bug Fix 5136678 Added 'Mixed' Category Code
	      oe.order_category_code IN ('RETURN','MIXED') AND
	      oe.order_number = l_skey_value;

Line: 112

	SELECT hza.party_id, hza.cust_account_id, oe.header_id, oe.org_id, oe.sold_to_contact_id
	FROM oe_order_headers oe, hz_cust_accounts hza
	WHERE oe.sold_to_org_id = hza.cust_account_id AND
--Bug Fix 5136678 Added 'Mixed' Category Code
	      oe.order_category_code IN ('RETURN','MIXED') AND
	      oe.order_number = l_skey_value;

Line: 121

	SELECT party_id, contract_id
	FROM oks_ent_hdr_summary_v
        WHERE contract_number = l_skey_value;

Line: 127

	SELECT hca.party_id, hca.cust_account_id, csb.system_id
	FROM csi_systems_vl csb, hz_cust_accounts hca
	WHERE csb.customer_id = hca.cust_account_id
	AND csb.name = l_skey_value;

Line: 134

	SELECT item.owner_party_id, item.owner_party_account_id, instance_id
	FROM csi_item_instances item
	WHERE item.external_reference IS NOT NULL
	AND item.external_reference = l_skey_value;

Line: 141

	SELECT item.owner_party_id, item.owner_party_account_id, instance_id
	FROM csi_item_instances item
	WHERE item.serial_number  IS NOT NULL
	AND item.serial_number = l_skey_value;

Line: 148

       SELECT owner_party_id, owner_party_account_id, instance_id
       FROM csi_item_instances
       WHERE owner_party_source_table = 'HZ_PARTIES'
       AND instance_description IS NOT NULL
       AND instance_description = l_skey_value;

Line: 156

       SELECT owner_party_id, owner_party_account_id, instance_id
       FROM csi_item_instances
       WHERE owner_party_source_table = 'HZ_PARTIES'
       AND instance_number IS NOT NULL
       AND instance_number = l_skey_value;

Line: 164

 	SELECT party_id
        FROM hz_parties
	WHERE jgzz_fiscal_code = l_skey_value;