eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PNP_CMERGE dependencies on RA_CUSTOMER_MERGES

Line 17: FROM ra_customer_merges racm

13: CURSOR leases IS
14: SELECT lease_id
15: FROM pn_leases
16: WHERE customer_id IN (SELECT racm.duplicate_id
17: FROM ra_customer_merges racm
18: WHERE racm.process_flag = 'N'
19: AND racm.request_id = req_id
20: AND racm.set_number = set_num
21: )

Line 28: FROM ra_customer_merges racm

24: CURSOR tenencies IS
25: SELECT tenancy_id
26: FROM pn_tenancies
27: WHERE customer_id IN (SELECT racm.duplicate_id
28: FROM ra_customer_merges racm
29: WHERE racm.process_flag = 'N'
30: AND racm.request_id = req_id
31: AND racm.set_number = set_num
32: )

Line 39: FROM ra_customer_merges racm

35: CURSOR tenencies_history IS
36: SELECT tenancy_history_id
37: FROM pn_tenancies_history
38: WHERE customer_id IN (SELECT racm.duplicate_id
39: FROM ra_customer_merges racm
40: WHERE racm.process_flag = 'N'
41: AND racm.request_id = req_id
42: AND racm.set_number = set_num
43: )

Line 50: FROM ra_customer_merges racm

46: CURSOR term_templates IS
47: SELECT term_template_id
48: FROM pn_term_templates
49: WHERE customer_id IN (SELECT racm.duplicate_id
50: FROM ra_customer_merges racm
51: WHERE racm.process_flag = 'N'
52: AND racm.request_id = req_id
53: AND racm.set_number = set_num
54: )

Line 61: FROM ra_customer_merges racm

57: CURSOR pmt_terms IS
58: SELECT payment_term_id
59: FROM pn_payment_terms
60: WHERE customer_id IN (SELECT racm.duplicate_id
61: FROM ra_customer_merges racm
62: WHERE racm.process_flag = 'N'
63: AND racm.request_id = req_id
64: AND racm.set_number = set_num
65: )

Line 72: FROM ra_customer_merges racm

68: CURSOR pmt_items IS
69: SELECT payment_item_id
70: FROM pn_payment_items
71: WHERE customer_id IN (SELECT racm.duplicate_id
72: FROM ra_customer_merges racm
73: WHERE racm.process_flag = 'N'
74: AND racm.request_id = req_id
75: AND racm.set_number = set_num
76: )

Line 83: FROM ra_customer_merges racm

79: CURSOR rec_agreements IS
80: SELECT rec_agreement_id
81: FROM pn_rec_agreements
82: WHERE customer_id IN (SELECT racm.duplicate_id
83: FROM ra_customer_merges racm
84: WHERE racm.process_flag = 'N'
85: AND racm.request_id = req_id
86: AND racm.set_number = set_num
87: )

Line 95: FROM ra_customer_merges racm

91: SELECT area_class_dtl_id
92: FROM pn_rec_arcl_dtlln
93: WHERE cust_account_id IN
94: (SELECT racm.duplicate_id
95: FROM ra_customer_merges racm
96: WHERE racm.process_flag = 'N'
97: AND racm.request_id = req_id
98: AND racm.set_number = set_num
99: )

Line 107: FROM ra_customer_merges racm

103: SELECT expense_class_dtl_id
104: FROM pn_rec_expcl_dtlln
105: WHERE cust_account_id IN
106: (SELECT racm.duplicate_id
107: FROM ra_customer_merges racm
108: WHERE racm.process_flag = 'N'
109: AND racm.request_id = req_id
110: AND racm.set_number = set_num
111: )

Line 119: FROM ra_customer_merges racm

115: SELECT rec_period_lines_id
116: FROM pn_rec_period_lines
117: WHERE cust_account_id IN
118: (SELECT racm.duplicate_id
119: FROM ra_customer_merges racm
120: WHERE racm.process_flag = 'N'
121: AND racm.request_id = req_id
122: AND racm.set_number = set_num
123: )

Line 131: FROM ra_customer_merges racm

127: SELECT cust_space_assign_id
128: FROM pn_space_assign_cust
129: WHERE cust_account_id IN
130: (SELECT racm.duplicate_id
131: FROM ra_customer_merges racm
132: WHERE racm.process_flag = 'N'
133: AND racm.request_id = req_id
134: AND racm.set_number = set_num
135: )

Line 339: , RA_CUSTOMER_MERGES m

335: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
336: ,yt.LEASE_ID
337: ,yt.CUSTOMER_ID
338: FROM PN_LEASES yt
339: , RA_CUSTOMER_MERGES m
340: WHERE yt.CUSTOMER_ID = m.DUPLICATE_ID
341: AND m.process_flag = 'N'
342: AND m.request_id = req_id
343: AND m.set_number = set_num;

Line 501: ,RA_CUSTOMER_MERGES m

497: ,yt.TENANCY_ID
498: ,yt.CUSTOMER_ID
499: ,yt.CUSTOMER_SITE_USE_ID
500: FROM PN_TENANCIES yt
501: ,RA_CUSTOMER_MERGES m
502: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
503: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID)
504: AND m.process_flag = 'N'
505: AND m.request_id = req_id

Line 672: RA_CUSTOMER_MERGES m

668: ,yt.TENANCY_HISTORY_ID
669: ,yt.CUSTOMER_ID
670: ,yt.CUSTOMER_SITE_USE_ID
671: FROM PN_TENANCIES_HISTORY yt,
672: RA_CUSTOMER_MERGES m
673: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
674: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID)
675: AND m.process_flag = 'N'
676: AND m.request_id = req_id

Line 850: RA_CUSTOMER_MERGES m

846: ,yt.CUSTOMER_ID
847: ,yt.CUSTOMER_SITE_USE_ID
848: ,yt.CUST_SHIP_SITE_ID
849: FROM PN_TERM_TEMPLATES yt,
850: RA_CUSTOMER_MERGES m
851: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
852: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
853: OR yt.CUST_SHIP_SITE_ID = m.DUPLICATE_SITE_ID)
854: AND m.process_flag = 'N'

Line 1038: RA_CUSTOMER_MERGES m

1034: ,yt.CUSTOMER_ID
1035: ,yt.CUSTOMER_SITE_USE_ID
1036: ,yt.CUST_SHIP_SITE_ID
1037: FROM PN_PAYMENT_TERMS yt,
1038: RA_CUSTOMER_MERGES m
1039: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
1040: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
1041: OR yt.CUST_SHIP_SITE_ID = m.DUPLICATE_SITE_ID)
1042: AND m.process_flag = 'N'

Line 1222: ,RA_CUSTOMER_MERGES m

1218: ,yt.CUSTOMER_ID
1219: ,yt.CUSTOMER_SITE_USE_ID
1220: ,yt.CUST_SHIP_SITE_ID
1221: FROM PN_PAYMENT_ITEMS yt
1222: ,RA_CUSTOMER_MERGES m
1223: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
1224: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
1225: OR yt.CUST_SHIP_SITE_ID = m.DUPLICATE_SITE_ID )
1226: AND m.process_flag = 'N'

Line 1399: ,RA_CUSTOMER_MERGES m

1395: ,yt.REC_AGREEMENT_ID
1396: ,yt.CUSTOMER_ID
1397: ,yt.CUST_SITE_ID
1398: FROM PN_REC_AGREEMENTS yt
1399: ,RA_CUSTOMER_MERGES m
1400: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
1401: OR yt.CUST_SITE_ID = m.DUPLICATE_SITE_ID)
1402: AND m.process_flag = 'N'
1403: AND m.request_id = req_id

Line 1559: ,RA_CUSTOMER_MERGES m

1555: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
1556: ,yt.AREA_CLASS_DTL_ID
1557: ,yt.CUST_ACCOUNT_ID
1558: FROM PN_REC_ARCL_DTLLN yt
1559: ,RA_CUSTOMER_MERGES m
1560: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
1561: AND m.process_flag = 'N'
1562: AND m.request_id = req_id
1563: AND m.set_number = set_num;

Line 1710: ,RA_CUSTOMER_MERGES M

1706: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
1707: ,yt.EXPENSE_CLASS_LINE_ID
1708: ,yt.CUST_ACCOUNT_ID
1709: FROM PN_REC_EXPCL_DTLLN yt
1710: ,RA_CUSTOMER_MERGES M
1711: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
1712: AND m.process_flag = 'N'
1713: AND m.request_id = req_id
1714: AND m.set_number = set_num;

Line 1860: ,RA_CUSTOMER_MERGES m

1856: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
1857: ,yt.REC_PERIOD_LINES_ID
1858: ,yt.CUST_ACCOUNT_ID
1859: FROM PN_REC_PERIOD_LINES yt
1860: ,RA_CUSTOMER_MERGES m
1861: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
1862: AND m.process_flag = 'N'
1863: AND m.request_id = req_id
1864: AND m.set_number = set_num;

Line 2019: ,RA_CUSTOMER_MERGES m

2015: ,yt.cust_space_assign_id
2016: ,yt.CUST_ACCOUNT_ID
2017: ,yt.SITE_USE_ID
2018: FROM PN_SPACE_ASSIGN_CUST yt
2019: ,RA_CUSTOMER_MERGES m
2020: WHERE ( yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
2021: OR yt.SITE_USE_ID = m.DUPLICATE_SITE_ID )
2022: AND m.process_flag = 'N'
2023: AND m.request_id = req_id