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 HZ_CUST_ACCOUNTS

Line 164: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL1_ORIG_LIST(I) and status = 'A';

160: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
161: -- Changed for all loop to for loop to fix 14492050 Snuthala
162: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop
163:
164: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL1_ORIG_LIST(I) and status = 'A';
165: if l_acc_status_cnt = 0 then
166:
167: UPDATE IEX_SCORE_HISTORIES yt SET
168: SCORE_OBJECT_ID = NUM_COL1_NEW_LIST(I)

Line 541: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL1_ORIG_LIST(I) and status = 'A';

537: -- FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
538: -- Changed for all loop to for loop to fix 14492050 Snuthala
539: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop
540:
541: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL1_ORIG_LIST(I) and status = 'A';
542: if l_acc_status_cnt = 0 then
543: UPDATE IEX_DUNNINGS yt SET
544: DUNNING_OBJECT_ID = NUM_COL1_NEW_LIST(I)
545: , LAST_UPDATE_DATE = SYSDATE

Line 748: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca

744: ,yt.STRATEGY_ID
745: ,yt.CUST_ACCOUNT_ID
746: ,hca.party_id
747: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
748: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca
749: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
750: hca.cust_account_id = m.customer_id AND
751: m.process_flag = 'N' AND
752: m.request_id = req_id AND

Line 864: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL1_ORIG_LIST(I) and status = 'A';

860: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
861: -- Changed for all loop to for loop to fix 14492050 Snuthala
862: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop
863:
864: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL1_ORIG_LIST(I) and status = 'A';
865: if l_acc_status_cnt = 0 then
866:
867: UPDATE IEX_STRATEGIES yt SET
868: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)

Line 963: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL2_ORIG_LIST(I) and status = 'A';

959: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
960: -- Changed for all loop to for loop to fix 14492050 Snuthala
961: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop
962:
963: select count(CUST_ACCOUNT_ID) into l_acc_status_cnt from hz_cust_accounts where CUST_ACCOUNT_ID = NUM_COL2_ORIG_LIST(I) and status = 'A';
964: if l_acc_status_cnt = 0 then
965:
966: UPDATE IEX_STRATEGIES yt SET
967: JTF_OBJECT_ID = NUM_COL2_NEW_LIST(I)

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