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_SITE_USES_ALL

Line 258: select count(CUST_ACCT_site_id) into l_acc_status_cnt from hz_cust_site_uses_all where cust_acct_site_id = NUM_COL2_ORIG_LIST(I) and status = 'A';

254: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
255: -- Changed for all loop to for loop to fix 14492050 Snuthala
256: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop
257:
258: select count(CUST_ACCT_site_id) into l_acc_status_cnt from hz_cust_site_uses_all where cust_acct_site_id = NUM_COL2_ORIG_LIST(I) and status = 'A';
259: if l_acc_status_cnt = 0 then
260: UPDATE IEX_SCORE_HISTORIES yt SET
261: SCORE_OBJECT_ID = NUM_COL2_NEW_LIST(I)
262: , LAST_UPDATE_DATE = SYSDATE

Line 347: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL3_ORIG_LIST(I) and status = 'A';

343: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
344: -- Changed for all loop to for loop to fix 14492050 Snuthala
345: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop
346:
347: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL3_ORIG_LIST(I) and status = 'A';
348: if l_acc_status_cnt = 0 then
349: UPDATE IEX_SCORE_HISTORIES yt SET
350: SCORE_OBJECT_ID = NUM_COL3_NEW_LIST(I)
351: , LAST_UPDATE_DATE = SYSDATE

Line 648: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL2_ORIG_LIST(I) and status = 'A';

644: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
645: -- Changed for all loop to for loop to fix 14492050 Snuthala
646: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT loop
647:
648: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL2_ORIG_LIST(I) and status = 'A';
649: if l_acc_status_cnt = 0 then
650: UPDATE IEX_DUNNINGS yt SET
651: DUNNING_OBJECT_ID = NUM_COL2_NEW_LIST(I)
652: , LAST_UPDATE_DATE = SYSDATE

Line 982: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL2_ORIG_LIST(I) and status = 'A';

978: end loop;
979: -- End for fix 14492050 Snuthala
980: -- Begin Bug #6652858 bibeura 11-Dec-2007
981: for I in MERGE_HEADER_ID_LIST.first..MERGE_HEADER_ID_LIST.last loop
982: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL2_ORIG_LIST(I) and status = 'A';
983: if l_acc_status_cnt = 0 then
984: --Added filter for bug#8663669 by snuthala on 23-07-2009 to cancel only open and onhold strategies
985: IF STATUS_CODE_LIST(I) in ('OPEN','ONHOLD') then
986: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',

Line 1073: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL3_ORIG_LIST(I) and status = 'A';

1069: END IF;
1070: --FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1071: -- Changed for all loop to for loop to fix 14492050 Snuthala
1072: for I in MERGE_HEADER_ID_LIST.first..MERGE_HEADER_ID_LIST.last loop
1073: select count(site_use_id) into l_acc_status_cnt from hz_cust_site_uses_all where site_use_id = NUM_COL3_ORIG_LIST(I) and status = 'A';
1074: if l_acc_status_cnt = 0 then
1075: UPDATE IEX_STRATEGIES yt SET
1076: -- CUST_ACCOUNT_ID = NUM_COL3_NEW_LIST(I) Updated for bug#6974531 by schekuri on 14-Aug-2008
1077: JTF_OBJECT_ID = NUM_COL3_NEW_LIST(I)