APPS.OKE_FIX_MERGE_PUB SQL Statements

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

Line: 10

  SELECT CUSTOMER_ID,DUPLICATE_ID,PROGRAM_UPDATE_DATE
  FROM RA_CUSTOMER_MERGES
  WHERE DUPLICATE_ID=merge_from_acct
  AND PROGRAM_UPDATE_DATE > record_date
  AND PROGRAM_UPDATE_DATE > program_date
  ORDER BY PROGRAM_UPDATE_DATE;

Line: 31

				record_date,l_merge_row.PROGRAM_UPDATE_DATE);

Line: 40

  SELECT CUSTOMER_SITE_ID,DUPLICATE_SITE_ID,PROGRAM_UPDATE_DATE
  FROM RA_CUSTOMER_MERGES
  WHERE DUPLICATE_SITE_ID=merge_from_site_use
  AND PROGRAM_UPDATE_DATE > record_date
  AND PROGRAM_UPDATE_DATE > program_date
  ORDER BY PROGRAM_UPDATE_DATE;

Line: 61

				record_date,l_merge_row.PROGRAM_UPDATE_DATE);

Line: 68

  SELECT id,jtot_object1_code,
	object1_id1,object1_id2,last_update_date
  FROM okc_k_party_roles_b
  WHERE DNZ_CHR_ID=k_header_id
  AND JTOT_OBJECT1_CODE IN
    ('OKE_CUST_KADMIN','OKE_BILLTO','OKE_CUSTACCT','OKE_MARKFOR','OKE_SHIPTO');

Line: 89

				l_party_role.last_update_date,to_date('01-01-1990','MM-DD-YYYY'));

Line: 91

		UPDATE OKC_K_PARTY_ROLES_B
		SET OBJECT1_ID1 = l_final_id,
		LAST_UPDATE_DATE = SYSDATE,
		LAST_UPDATED_BY = -1
		WHERE ID = l_party_role.id;

Line: 99

				l_party_role.last_update_date,to_date('01-01-1990','MM-DD-YYYY'));

Line: 101

		UPDATE OKC_K_PARTY_ROLES_B
	 	SET OBJECT1_ID1 = l_final_id,
		LAST_UPDATE_DATE = SYSDATE,
		LAST_UPDATED_BY = -1
		WHERE ID = l_party_role.id;