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.AR_CMGT_ACCOUNT_MERGE dependencies on AR_TRX_BAL_SUMMARY

Line 299: | Account merge procedure for the table, AR_TRX_BAL_SUMMARY

295: |
296: | PROCEDURE
297: | TRX_BAL_SUMMARY_ACCOUNT_MERGE
298: | DESCRIPTION :
299: | Account merge procedure for the table, AR_TRX_BAL_SUMMARY
300: |
301: |
302: |--------------------------------------------------------------*/
303:

Line 315: AR_TRX_BAL_SUMMARY.CUST_ACCOUNT_ID%TYPE

311: INDEX BY BINARY_INTEGER;
312: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
313:
314: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
315: AR_TRX_BAL_SUMMARY.CUST_ACCOUNT_ID%TYPE
316: INDEX BY BINARY_INTEGER;
317: PRIMARY_KEY1_LIST CUST_ACCOUNT_ID_LIST_TYPE;
318:
319: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF

Line 320: AR_TRX_BAL_SUMMARY.SITE_USE_ID%TYPE

316: INDEX BY BINARY_INTEGER;
317: PRIMARY_KEY1_LIST CUST_ACCOUNT_ID_LIST_TYPE;
318:
319: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
320: AR_TRX_BAL_SUMMARY.SITE_USE_ID%TYPE
321: INDEX BY BINARY_INTEGER;
322: PRIMARY_KEY2_LIST SITE_USE_ID_LIST_TYPE;
323:
324: TYPE CURRENCY_LIST_TYPE IS TABLE OF

Line 325: AR_TRX_BAL_SUMMARY.CURRENCY%TYPE

321: INDEX BY BINARY_INTEGER;
322: PRIMARY_KEY2_LIST SITE_USE_ID_LIST_TYPE;
323:
324: TYPE CURRENCY_LIST_TYPE IS TABLE OF
325: AR_TRX_BAL_SUMMARY.CURRENCY%TYPE
326: INDEX BY BINARY_INTEGER;
327: PRIMARY_KEY3_LIST CURRENCY_LIST_TYPE;
328:
329: TYPE ORG_ID_LIST_TYPE IS TABLE OF

Line 330: AR_TRX_BAL_SUMMARY.ORG_ID%TYPE

326: INDEX BY BINARY_INTEGER;
327: PRIMARY_KEY3_LIST CURRENCY_LIST_TYPE;
328:
329: TYPE ORG_ID_LIST_TYPE IS TABLE OF
330: AR_TRX_BAL_SUMMARY.ORG_ID%TYPE
331: INDEX BY BINARY_INTEGER;
332: PRIMARY_KEY4_LIST ORG_ID_LIST_TYPE;
333:
334: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;

Line 345: AR_TRX_BAL_SUMMARY.LAST_PAYMENT_NUMBER%type

341: TYPE DATE_LIST_TYPE IS TABLE OF DATE
342: INDEX BY BINARY_INTEGER;
343:
344: TYPE PAYMENT_NUMBER_LIST_TYPE IS TABLE OF
345: AR_TRX_BAL_SUMMARY.LAST_PAYMENT_NUMBER%type
346: INDEX BY BINARY_INTEGER;
347:
348: TYPE NUMBER_LIST_TYPE IS TABLE OF NUMBER
349: INDEX BY BINARY_INTEGER;

Line 417: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m

413: ,PAST_DUE_INV_INST_COUNT
414: ,LAST_PAYMENT_AMOUNT
415: ,LAST_PAYMENT_DATE
416: ,LAST_PAYMENT_NUMBER
417: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m
418: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
419: AND DECODE(yt.SITE_USE_ID , -99, m.DUPLICATE_SITE_ID,
420: yt.SITE_USE_ID) = m.DUPLICATE_SITE_ID
421: AND m.process_flag = 'N'

Line 460: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m

456: ,PAST_DUE_INV_INST_COUNT
457: ,LAST_PAYMENT_AMOUNT
458: ,LAST_PAYMENT_DATE
459: ,LAST_PAYMENT_NUMBER
460: FROM AR_TRX_BAL_SUMMARY yt, ra_customer_merges m
461: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
462: AND yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
463: AND m.process_flag = 'N'
464: AND m.request_id = req_id

Line 474: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_TRX_BAL_SUMMARY',FALSE);

470: IF process_mode='LOCK' THEN
471: NULL;
472: ELSE
473: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
474: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_TRX_BAL_SUMMARY',FALSE);
475: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
476: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
477:
478: open merged_records;

Line 579: 'AR_TRX_BAL_SUMMARY',

575: LAST_UPDATE_LOGIN,
576: LAST_UPDATE_DATE,
577: LAST_UPDATED_BY
578: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
579: 'AR_TRX_BAL_SUMMARY',
580: MERGE_HEADER_ID_LIST(I),
581: PRIMARY_KEY1_LIST(I),
582: PRIMARY_KEY2_LIST(I),
583: PRIMARY_KEY3_LIST(I),

Line 627: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY ');

623: );
624:
625: arp_message.set_line( 'after Insert into HZ_CUSTOMER_MERGE_LOG');
626: END IF;
627: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY ');
628: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
629: UPDATE AR_TRX_BAL_SUMMARY yt SET
630: (BEST_CURRENT_RECEIVABLES
631: ,TOTAL_DSO_DAYS_CREDIT

Line 629: UPDATE AR_TRX_BAL_SUMMARY yt SET

625: arp_message.set_line( 'after Insert into HZ_CUSTOMER_MERGE_LOG');
626: END IF;
627: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY ');
628: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
629: UPDATE AR_TRX_BAL_SUMMARY yt SET
630: (BEST_CURRENT_RECEIVABLES
631: ,TOTAL_DSO_DAYS_CREDIT
632: ,OP_INVOICES_VALUE
633: ,OP_INVOICES_COUNT

Line 804: FROM ar_trx_bal_summary yt1

800: yt1.LAST_PAYMENT_NUMBER),
801: sysdate,
802: FND_GLOBAL.user_id,
803: FND_GLOBAL.login_id
804: FROM ar_trx_bal_summary yt1
805: WHERE yt1.cust_account_id = PRIMARY_KEY1_LIST(I)
806: AND yt1.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
807: AND yt1.CURRENCY=PRIMARY_KEY3_LIST(I)
808: AND yt1.ORG_ID=PRIMARY_KEY4_LIST(I)

Line 810: FROM AR_TRX_BAL_SUMMARY yt2

806: AND yt1.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
807: AND yt1.CURRENCY=PRIMARY_KEY3_LIST(I)
808: AND yt1.ORG_ID=PRIMARY_KEY4_LIST(I)
809: AND EXISTS ( SELECT 'X'
810: FROM AR_TRX_BAL_SUMMARY yt2
811: WHERE yt2.CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
812: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
813: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
814: AND yt2.ORG_ID=PRIMARY_KEY4_LIST(I) ))

Line 820: arp_message.set_line( 'after UPDATE AR_TRX_BAL_SUMMARY ');

816: AND yt.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
817: AND yt.CURRENCY=PRIMARY_KEY3_LIST(I)
818: AND yt.ORG_ID=PRIMARY_KEY4_LIST(I) ;
819:
820: arp_message.set_line( 'after UPDATE AR_TRX_BAL_SUMMARY ');
821: arp_message.set_line( 'before DELETE AR_TRX_BAL_SUMMARY');
822: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
823: DELETE AR_TRX_BAL_SUMMARY yt
824: WHERE yt.cust_account_id = PRIMARY_KEY1_LIST(I)

Line 821: arp_message.set_line( 'before DELETE AR_TRX_BAL_SUMMARY');

817: AND yt.CURRENCY=PRIMARY_KEY3_LIST(I)
818: AND yt.ORG_ID=PRIMARY_KEY4_LIST(I) ;
819:
820: arp_message.set_line( 'after UPDATE AR_TRX_BAL_SUMMARY ');
821: arp_message.set_line( 'before DELETE AR_TRX_BAL_SUMMARY');
822: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
823: DELETE AR_TRX_BAL_SUMMARY yt
824: WHERE yt.cust_account_id = PRIMARY_KEY1_LIST(I)
825: AND yt.SITE_USE_ID=PRIMARY_KEY2_LIST(I)

Line 823: DELETE AR_TRX_BAL_SUMMARY yt

819:
820: arp_message.set_line( 'after UPDATE AR_TRX_BAL_SUMMARY ');
821: arp_message.set_line( 'before DELETE AR_TRX_BAL_SUMMARY');
822: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
823: DELETE AR_TRX_BAL_SUMMARY yt
824: WHERE yt.cust_account_id = PRIMARY_KEY1_LIST(I)
825: AND yt.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
826: AND yt.CURRENCY=PRIMARY_KEY3_LIST(I)
827: AND yt.ORG_ID=PRIMARY_KEY4_LIST(I)

Line 829: FROM AR_TRX_BAL_SUMMARY yt2

825: AND yt.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
826: AND yt.CURRENCY=PRIMARY_KEY3_LIST(I)
827: AND yt.ORG_ID=PRIMARY_KEY4_LIST(I)
828: AND EXISTS ( SELECT 'X'
829: FROM AR_TRX_BAL_SUMMARY yt2
830: WHERE yt2.CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
831: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
832: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
833: AND yt2.ORG_ID=PRIMARY_KEY4_LIST(I) );

Line 835: arp_message.set_line( 'after DELETE AR_TRX_BAL_SUMMARY');

831: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
832: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
833: AND yt2.ORG_ID=PRIMARY_KEY4_LIST(I) );
834:
835: arp_message.set_line( 'after DELETE AR_TRX_BAL_SUMMARY');
836:
837: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY again');
838: /* bug4727614: Added not exists clause to prevent unique index error */
839: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 837: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY again');

833: AND yt2.ORG_ID=PRIMARY_KEY4_LIST(I) );
834:
835: arp_message.set_line( 'after DELETE AR_TRX_BAL_SUMMARY');
836:
837: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY again');
838: /* bug4727614: Added not exists clause to prevent unique index error */
839: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
840: UPDATE AR_TRX_BAL_SUMMARY yt SET
841: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)

Line 840: UPDATE AR_TRX_BAL_SUMMARY yt SET

836:
837: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY again');
838: /* bug4727614: Added not exists clause to prevent unique index error */
839: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
840: UPDATE AR_TRX_BAL_SUMMARY yt SET
841: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
842: ,SITE_USE_ID=DECODE(SITE_USE_ID, -99, -99, NUM_COL2_NEW_LIST(I))
843: , LAST_UPDATE_DATE=SYSDATE
844: , last_updated_by=arp_standard.profile.user_id

Line 851: FROM AR_TRX_BAL_SUMMARY yt2

847: AND SITE_USE_ID=PRIMARY_KEY2_LIST(I)
848: AND CURRENCY=PRIMARY_KEY3_LIST(I)
849: AND ORG_ID=PRIMARY_KEY4_LIST(I)
850: and not exists ( SELECT 'X'
851: FROM AR_TRX_BAL_SUMMARY yt2
852: WHERE yt2.CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
853: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
854: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
855: AND yt2.ORG_ID=PRIMARY_KEY4_LIST(I) );

Line 857: arp_message.set_line( 'after UPDATE AR_TRX_BAL_SUMMARY again');

853: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
854: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
855: AND yt2.ORG_ID=PRIMARY_KEY4_LIST(I) );
856:
857: arp_message.set_line( 'after UPDATE AR_TRX_BAL_SUMMARY again');
858: l_count := l_count + SQL%ROWCOUNT;
859: IF l_last_fetch THEN
860: EXIT;
861: END IF;