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.OTAP_CMERGE dependencies on OTA_FINANCE_HEADERS

Line 310: | Account merge procedure for the table, OTA_FINANCE_HEADERS

Line 325: OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%TYPE

321: INDEX BY BINARY_INTEGER;
322: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
323:
324: TYPE FINANCE_HEADER_ID_LIST_TYPE IS TABLE OF
325: OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%TYPE
326: INDEX BY BINARY_INTEGER;
327: PRIMARY_KEY_ID_LIST FINANCE_HEADER_ID_LIST_TYPE;
328:
329: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 330: OTA_FINANCE_HEADERS.CUSTOMER_ID%TYPE

326: INDEX BY BINARY_INTEGER;
327: PRIMARY_KEY_ID_LIST FINANCE_HEADER_ID_LIST_TYPE;
328:
329: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
330: OTA_FINANCE_HEADERS.CUSTOMER_ID%TYPE
331: INDEX BY BINARY_INTEGER;
332: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
333: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
334:

Line 337: OTA_FINANCE_HEADERS.ADDRESS_ID%TYPE

333: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
334:
335: -- Bug 3590109 Address Merge
336: TYPE ADDRESS_ID_LIST_TYPE IS TABLE OF
337: OTA_FINANCE_HEADERS.ADDRESS_ID%TYPE
338: INDEX BY BINARY_INTEGER;
339: NUM_COL2_ORIG_LIST ADDRESS_ID_LIST_TYPE;
340: NUM_COL2_NEW_LIST ADDRESS_ID_LIST_TYPE;
341:

Line 343: OTA_FINANCE_HEADERS.INVOICE_ADDRESS%TYPE

339: NUM_COL2_ORIG_LIST ADDRESS_ID_LIST_TYPE;
340: NUM_COL2_NEW_LIST ADDRESS_ID_LIST_TYPE;
341:
342: TYPE INVOICE_ADDR_STR_LIST_TYPE IS TABLE OF
343: OTA_FINANCE_HEADERS.INVOICE_ADDRESS%TYPE
344: INDEX BY BINARY_INTEGER;
345: VCHAR_COL1_ORIG_LIST INVOICE_ADDR_STR_LIST_TYPE;
346: VCHAR_COL1_NEW_LIST INVOICE_ADDR_STR_LIST_TYPE;
347:

Line 355: FROM OTA_FINANCE_HEADERS yt, ra_customer_merges m

351: ,FINANCE_HEADER_ID
352: ,yt.CUSTOMER_ID
353: ,yt.ADDRESS_ID
354: ,yt.INVOICE_ADDRESS
355: FROM OTA_FINANCE_HEADERS yt, ra_customer_merges m
356: WHERE (
357: yt.CUSTOMER_ID = m.DUPLICATE_ID
358: ) AND m.process_flag = 'N'
359: AND m.request_id = req_id

Line 392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_FINANCE_HEADERS',FALSE);

388: IF process_mode='LOCK' THEN
389: NULL;
390: ELSE
391: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_FINANCE_HEADERS',FALSE);
393: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
394: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
395:
396: open merged_records;

Line 447: 'OTA_FINANCE_HEADERS',

443: LAST_UPDATE_LOGIN,
444: LAST_UPDATE_DATE,
445: LAST_UPDATED_BY
446: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
447: 'OTA_FINANCE_HEADERS',
448: MERGE_HEADER_ID_LIST(I),
449: PRIMARY_KEY_ID_LIST(I),
450: NUM_COL1_ORIG_LIST(I),
451: NUM_COL1_NEW_LIST(I),

Line 467: UPDATE OTA_FINANCE_HEADERS yt SET

463: hz_utility_pub.LAST_UPDATED_BY
464: );
465:
466: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
467: UPDATE OTA_FINANCE_HEADERS yt SET
468: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
469: -- Bug 3590109 Address Merge
470: , ADDRESS_ID=NUM_COL2_NEW_LIST(I)
471: , INVOICE_ADDRESS=VCHAR_COL1_NEW_LIST(I)