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_SUMMARY

Line 879: | Account merge procedure for the table, AR_TRX_SUMMARY

875: |
876: | PROCEDURE
877: | TRX_SUMMARY_ACCOUNT_MERGE
878: | DESCRIPTION :
879: | Account merge procedure for the table, AR_TRX_SUMMARY
880: | Bug4502961: Modified cursor merged_records to avoid error
881: |
882: |--------------------------------------------------------------*/
883:

Line 895: AR_TRX_SUMMARY.CUST_ACCOUNT_ID%TYPE

891: INDEX BY BINARY_INTEGER;
892: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
893:
894: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
895: AR_TRX_SUMMARY.CUST_ACCOUNT_ID%TYPE
896: INDEX BY BINARY_INTEGER;
897: PRIMARY_KEY1_LIST CUST_ACCOUNT_ID_LIST_TYPE;
898:
899: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF

Line 900: AR_TRX_SUMMARY.SITE_USE_ID%TYPE

896: INDEX BY BINARY_INTEGER;
897: PRIMARY_KEY1_LIST CUST_ACCOUNT_ID_LIST_TYPE;
898:
899: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
900: AR_TRX_SUMMARY.SITE_USE_ID%TYPE
901: INDEX BY BINARY_INTEGER;
902: PRIMARY_KEY2_LIST SITE_USE_ID_LIST_TYPE;
903:
904: TYPE CURRENCY_LIST_TYPE IS TABLE OF

Line 905: AR_TRX_SUMMARY.CURRENCY%TYPE

901: INDEX BY BINARY_INTEGER;
902: PRIMARY_KEY2_LIST SITE_USE_ID_LIST_TYPE;
903:
904: TYPE CURRENCY_LIST_TYPE IS TABLE OF
905: AR_TRX_SUMMARY.CURRENCY%TYPE
906: INDEX BY BINARY_INTEGER;
907: PRIMARY_KEY3_LIST CURRENCY_LIST_TYPE;
908:
909: TYPE AS_OF_DATE_LIST_TYPE IS TABLE OF

Line 910: AR_TRX_SUMMARY.AS_OF_DATE%TYPE

906: INDEX BY BINARY_INTEGER;
907: PRIMARY_KEY3_LIST CURRENCY_LIST_TYPE;
908:
909: TYPE AS_OF_DATE_LIST_TYPE IS TABLE OF
910: AR_TRX_SUMMARY.AS_OF_DATE%TYPE
911: INDEX BY BINARY_INTEGER;
912: PRIMARY_KEY4_LIST AS_OF_DATE_LIST_TYPE;
913:
914: TYPE ORG_ID_LIST_TYPE IS TABLE OF

Line 915: AR_TRX_SUMMARY.ORG_ID%TYPE

911: INDEX BY BINARY_INTEGER;
912: PRIMARY_KEY4_LIST AS_OF_DATE_LIST_TYPE;
913:
914: TYPE ORG_ID_LIST_TYPE IS TABLE OF
915: AR_TRX_SUMMARY.ORG_ID%TYPE
916: INDEX BY BINARY_INTEGER;
917: PRIMARY_KEY5_LIST ORG_ID_LIST_TYPE;
918:
919: TYPE NUMBER_LIST_TYPE IS TABLE OF NUMBER

Line 1010: FROM AR_TRX_SUMMARY yt, ra_customer_merges m

1006: ,LARGEST_INV_CUST_TRX_ID
1007: ,DAYS_CREDIT_GRANTED_SUM
1008: ,NSF_STOP_PAYMENT_COUNT
1009: ,NSF_STOP_PAYMENT_AMOUNT
1010: FROM AR_TRX_SUMMARY yt, ra_customer_merges m
1011: WHERE yt.cust_account_id = m.duplicate_id
1012: AND DECODE( yt.site_use_id , -99, m.duplicate_site_id,
1013: yt.site_use_id ) = m.duplicate_site_id
1014: AND m.process_flag = 'N'

Line 1026: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_TRX_SUMMARY',FALSE);

1022: IF process_mode='LOCK' THEN
1023: NULL;
1024: ELSE
1025: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1026: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_TRX_SUMMARY',FALSE);
1027: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1028: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1029:
1030: open merged_records;

Line 1144: 'AR_TRX_SUMMARY',

1140: LAST_UPDATE_LOGIN,
1141: LAST_UPDATE_DATE,
1142: LAST_UPDATED_BY
1143: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1144: 'AR_TRX_SUMMARY',
1145: MERGE_HEADER_ID_LIST(I),
1146: PRIMARY_KEY1_LIST(I),
1147: PRIMARY_KEY2_LIST(I),
1148: PRIMARY_KEY3_LIST(I),

Line 1199: UPDATE AR_TRX_SUMMARY yt

1195: hz_utility_pub.LAST_UPDATED_BY
1196: );
1197: END IF;
1198: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1199: UPDATE AR_TRX_SUMMARY yt
1200: SET ( OP_BAL_HIGH_WATERMARK
1201: ,TOTAL_CASH_RECEIPTS_VALUE
1202: ,TOTAL_CASH_RECEIPTS_COUNT
1203: ,TOTAL_INVOICES_VALUE

Line 1436: FROM ar_trx_summary yt1

1432: nvl(yt1.NSF_STOP_PAYMENT_AMOUNT,0)),
1433: sysdate,
1434: FND_GLOBAL.user_id,
1435: FND_GLOBAL.login_id
1436: FROM ar_trx_summary yt1
1437: WHERE yt1.cust_account_id = PRIMARY_KEY1_LIST(I)
1438: AND yt1.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
1439: AND yt1.CURRENCY=PRIMARY_KEY3_LIST(I)
1440: AND yt1.AS_OF_DATE=PRIMARY_KEY4_LIST(I)

Line 1443: FROM AR_TRX_SUMMARY yt2

1439: AND yt1.CURRENCY=PRIMARY_KEY3_LIST(I)
1440: AND yt1.AS_OF_DATE=PRIMARY_KEY4_LIST(I)
1441: AND yt1.ORG_ID=PRIMARY_KEY5_LIST(I)
1442: AND EXISTS ( SELECT 'X'
1443: FROM AR_TRX_SUMMARY yt2
1444: WHERE yt2.CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1445: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1446: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
1447: AND yt2.AS_OF_DATE=PRIMARY_KEY4_LIST(I)

Line 1456: DELETE AR_TRX_SUMMARY yt

1452: AND yt.AS_OF_DATE=PRIMARY_KEY4_LIST(I)
1453: AND yt.ORG_ID=PRIMARY_KEY5_LIST(I) ;
1454:
1455: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1456: DELETE AR_TRX_SUMMARY yt
1457: WHERE yt.cust_account_id = PRIMARY_KEY1_LIST(I)
1458: AND yt.SITE_USE_ID=PRIMARY_KEY2_LIST(I)
1459: AND yt.CURRENCY=PRIMARY_KEY3_LIST(I)
1460: AND yt.AS_OF_DATE=PRIMARY_KEY4_LIST(I)

Line 1463: FROM AR_TRX_SUMMARY yt2

1459: AND yt.CURRENCY=PRIMARY_KEY3_LIST(I)
1460: AND yt.AS_OF_DATE=PRIMARY_KEY4_LIST(I)
1461: AND yt.ORG_ID=PRIMARY_KEY5_LIST(I)
1462: AND EXISTS ( SELECT 'X'
1463: FROM AR_TRX_SUMMARY yt2
1464: WHERE yt2.CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1465: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1466: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
1467: AND yt2.AS_OF_DATE=PRIMARY_KEY4_LIST(I)

Line 1472: UPDATE AR_TRX_SUMMARY yt SET

1468: AND yt2.ORG_ID=PRIMARY_KEY5_LIST(I) );
1469:
1470:
1471: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1472: UPDATE AR_TRX_SUMMARY yt SET
1473: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1474: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1475: , LAST_UPDATE_DATE=SYSDATE
1476: , last_updated_by=arp_standard.profile.user_id

Line 1486: FROM AR_TRX_SUMMARY yt2

1482: AND ORG_ID=PRIMARY_KEY5_LIST(I)
1483: AND NOT EXISTS
1484: (
1485: SELECT 'X'
1486: FROM AR_TRX_SUMMARY yt2
1487: WHERE yt2.CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1488: AND yt2.SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1489: AND yt2.CURRENCY=PRIMARY_KEY3_LIST(I)
1490: AND yt2.AS_OF_DATE=PRIMARY_KEY4_LIST(I)