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.IEX_MERGE_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1143: -- Changed cusrsor to join with ar_payment_schedules_all ps,iex_delinquencies_all del to fix 14492050 Snuthala

1139: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1140: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1141:
1142: l_profile_val VARCHAR2(30);
1143: -- Changed cusrsor to join with ar_payment_schedules_all ps,iex_delinquencies_all del to fix 14492050 Snuthala
1144: CURSOR merged_records IS
1145: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1146: ,yt.PROMISE_DETAIL_ID
1147: ,yt.CUST_ACCOUNT_ID

Line 1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del

1144: CURSOR merged_records IS
1145: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1146: ,yt.PROMISE_DETAIL_ID
1147: ,yt.CUST_ACCOUNT_ID
1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del
1149: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1150: m.process_flag = 'N' AND
1151: m.request_id = req_id AND
1152: m.set_number = set_num AND

Line 1299: -- Changed cusrsor to join with ar_payment_schedules_all ps to fix 14492050 snuthala

1295: m.process_flag = 'N' AND
1296: m.request_id = req_id AND
1297: m.set_number = set_num;
1298: */
1299: -- Changed cusrsor to join with ar_payment_schedules_all ps to fix 14492050 snuthala
1300: CURSOR merged_records IS
1301: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1302: ,yt.DELINQUENCY_ID
1303: ,yt.CUST_ACCOUNT_ID

Line 1305: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c, ar_payment_schedules_all ps

1301: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1302: ,yt.DELINQUENCY_ID
1303: ,yt.CUST_ACCOUNT_ID
1304: ,c.party_id
1305: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c, ar_payment_schedules_all ps
1306: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1307: m.process_flag = 'N' AND
1308: m.request_id = req_id AND
1309: m.set_number = set_num and

Line 1313: -- Changed cusrsor to join with ar_payment_schedules_all ps to fix 14492050 Snuthala

1309: m.set_number = set_num and
1310: m.customer_id = c.cust_account_id AND
1311: yt.PAYMENT_SCHEDULE_ID = ps.PAYMENT_SCHEDULE_ID AND
1312: yt.CUST_ACCOUNT_ID <> ps.CUSTOMER_ID ;
1313: -- Changed cusrsor to join with ar_payment_schedules_all ps to fix 14492050 Snuthala
1314: CURSOR merged_records1 IS
1315: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1316: ,yt.DELINQUENCY_ID
1317: ,yt.CUSTOMER_SITE_USE_ID

Line 1318: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m,ar_payment_schedules_all ar

1314: CURSOR merged_records1 IS
1315: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1316: ,yt.DELINQUENCY_ID
1317: ,yt.CUSTOMER_SITE_USE_ID
1318: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m,ar_payment_schedules_all ar
1319: WHERE yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID AND
1320: m.process_flag = 'N' AND
1321: m.request_id = req_id AND
1322: m.set_number = set_num AND