[Home] [Help]
3444: CURSOR merged_records IS
3445: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3446: , ID
3447: , CUST_ACCT_ID
3448: FROM OKL_LEASE_OPPORTUNITIES_B yt, ra_customer_merges m
3449: WHERE (yt.CUST_ACCT_ID = m.DUPLICATE_ID)
3450: AND m.process_flag = 'N'
3451: AND m.request_id = req_id
3452: AND m.set_number = set_num;
3975: CURSOR merged_records IS
3976: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3977: , ID
3978: , CUST_ACCT_ID
3979: FROM OKL_LEASE_APPLICATIONS_B yt, ra_customer_merges m
3980: WHERE (yt.CUST_ACCT_ID = m.DUPLICATE_ID)
3981: AND m.process_flag = 'N'
3982: AND m.request_id = req_id
3983: AND m.set_number = set_num;
4287: SELECT distinct CUSTOMER_MERGE_HEADER_ID
4288: ,yt.ID
4289: ,yt.CUSTOMER_ID
4290: ,yt.CUSTOMER_ADDRESS_ID
4291: FROM OKL_EXT_SELL_INVS_B yt, ra_customer_merges m
4292: WHERE (
4293: yt.CUSTOMER_ID = m.DUPLICATE_ID
4294: OR yt.CUSTOMER_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
4295: ) AND m.process_flag = 'N'
4467: ,ID
4468: ,BILL_TO_CUST_ACCT_ID
4469: ,BILL_TO_CUST_ACCT_SITE_USE_ID
4470: ,SHIP_TO_CUST_ACCT_SITE_USE_ID
4471: FROM OKL_TAX_SOURCES_T yt, ra_customer_merges m
4472: WHERE (
4473: yt.BILL_TO_CUST_ACCT_ID = m.DUPLICATE_ID
4474: OR yt.BILL_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID
4475: OR yt.SHIP_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID
4744: ,ID
4745: ,BILL_TO_CUST_ACCT_ID
4746: ,BILL_TO_CUST_ACCT_SITE_USE_ID
4747: ,SHIP_TO_CUST_ACCT_SITE_USE_ID
4748: FROM OKL_TAX_SOURCES yt, ra_customer_merges m
4749: WHERE (
4750: yt.BILL_TO_CUST_ACCT_ID = m.DUPLICATE_ID
4751: OR yt.BILL_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID
4752: OR yt.SHIP_TO_CUST_ACCT_SITE_USE_ID = m.DUPLICATE_SITE_ID
4984: SELECT distinct CUSTOMER_MERGE_HEADER_ID
4985: ,ID
4986: ,IBT_ID
4987: ,IXX_ID
4988: FROM OKL_TRX_AR_INVOICES_B yt, ra_customer_merges m
4989: WHERE (
4990: yt.IBT_ID = m.DUPLICATE_SITE_ID
4991: OR yt.IXX_ID = m.DUPLICATE_ID
4992: ) AND m.process_flag = 'N'
5119: CURSOR merged_records IS
5120: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5121: ,ID
5122: ,ILE_ID
5123: FROM OKL_TXL_RCPT_APPS_B yt, ra_customer_merges m
5124: WHERE (
5125: yt.ILE_ID = m.DUPLICATE_ID
5126: ) AND m.process_flag = 'N'
5127: AND m.request_id = req_id
5253: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5254: ,ID
5255: ,IXX_ID
5256: ,IBT_ID
5257: FROM OKL_CNSLD_AR_HDRS_B yt, ra_customer_merges m
5258: WHERE (
5259: yt.IXX_ID = m.DUPLICATE_ID
5260: OR yt.IBT_ID = m.DUPLICATE_SITE_ID
5261: ) AND m.process_flag = 'N'
5388: CURSOR merged_records IS
5389: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5390: ,ID
5391: ,ICA_ID
5392: FROM OKL_CNTR_LVLNG_GRPS_B yt, ra_customer_merges m
5393: WHERE (
5394: yt.ICA_ID = m.DUPLICATE_ID
5395: ) AND m.process_flag = 'N'
5396: AND m.request_id = req_id
5509: CURSOR merged_records IS
5510: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5511: ,ID
5512: ,REC_SITE_USES_PK
5513: FROM OKL_ACCT_SOURCES yt, ra_customer_merges m
5514: WHERE (
5515: yt.REC_SITE_USES_PK = m.DUPLICATE_SITE_ID
5516: ) AND m.process_flag = 'N'
5517: AND m.request_id = req_id
5632: CURSOR merged_records IS
5633: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5634: ,ID
5635: ,SHIPPING_ADDRESS_ID1
5636: FROM OKL_SUPP_INVOICE_DTLS yt, ra_customer_merges m
5637: WHERE (
5638: yt.SHIPPING_ADDRESS_ID1 = m.DUPLICATE_SITE_ID
5639: ) AND m.process_flag = 'N'
5640: AND m.request_id = req_id
5752: CURSOR merged_records IS
5753: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5754: ,ID
5755: ,SHIPPING_ADDRESS_ID1
5756: FROM OKL_SUPP_INVOICE_DTLS_H yt, ra_customer_merges m
5757: WHERE (
5758: yt.SHIPPING_ADDRESS_ID1 = m.DUPLICATE_SITE_ID
5759: ) AND m.process_flag = 'N'
5760: AND m.request_id = req_id
6282: FROM OKC_RULES_B rul
6283: , OKC_RG_PARTY_ROLES rgpr
6284: , OKC_RULE_GROUPS_B rgp
6285: , OKC_K_PARTY_ROLES_B yt
6286: , RA_CUSTOMER_MERGES m
6287: WHERE yt.cust_acct_id = m.duplicate_id
6288: AND rgpr.cpl_id = yt.id
6289: AND rgp.id = rgpr.rgp_id
6290: AND rgp.rgd_code = 'LAVENB'