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.OE_CUST_MERGE dependencies on OE_BLANKET_HEADERS_ALL

Line 6484: -- OE_BLANKET_HEADERS_ALL H

6480: RA_CUSTOMER_MERGES M3,
6481: RA_CUSTOMER_MERGES M4,
6482: RA_CUSTOMER_MERGES M5,
6483: -- changed for bug 3196900
6484: -- OE_BLANKET_HEADERS_ALL H
6485: OE_BLANKET_HEADERS H
6486: WHERE
6487: ( h.sold_to_org_id = m1.duplicate_id(+)
6488: and h.invoice_to_org_id = m2.duplicate_site_id(+)

Line 6536: -- OE_BLANKET_HEADERS_ALL H

6532: RA_CUSTOMER_MERGES M3,
6533: RA_CUSTOMER_MERGES M4,
6534: RA_CUSTOMER_MERGES M5,
6535: -- changed for bug 3196900
6536: -- OE_BLANKET_HEADERS_ALL H
6537: OE_BLANKET_HEADERS H
6538: WHERE
6539: ( h.sold_to_org_id = m1.duplicate_id(+)
6540: and h.invoice_to_org_id = m2.duplicate_site_id(+)

Line 6648: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_ALL', FALSE );

6644:
6645: IF (process_mode = 'LOCK') THEN
6646:
6647: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6648: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_ALL', FALSE );
6649:
6650: open merge_headers;
6651: close merge_headers;
6652:

Line 6767: 'OE_BLANKET_HEADERS_ALL',

6763: LAST_UPDATE_DATE,
6764: LAST_UPDATED_BY
6765: ) VALUES (
6766: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6767: 'OE_BLANKET_HEADERS_ALL',
6768: MERGE_HEADER_ID_LIST(I),
6769: hdr_header_id_tab(I),
6770: old_hdr_sold_to_org_id_tab(I),
6771: decode(hdr_sold_to_org_id_tab(I),NULL,old_hdr_sold_to_org_id_tab(I),hdr_sold_to_org_id_tab(i)),

Line 6794: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_all', FALSE );

6790: end if;
6791:
6792:
6793: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6794: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_all', FALSE );
6795:
6796: IF hdr_header_id_tab.COUNT <> 0 THEN
6797:
6798: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST

Line 6799: UPDATE OE_BLANKET_HEADERS_ALL H

6795:
6796: IF hdr_header_id_tab.COUNT <> 0 THEN
6797:
6798: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST
6799: UPDATE OE_BLANKET_HEADERS_ALL H
6800: SET sold_to_org_id = decode(hdr_sold_to_org_id_tab(i),null,sold_to_org_id,hdr_sold_to_org_id_tab(i)),
6801: invoice_to_org_id = decode(hdr_invoice_to_org_id_tab(i),null,invoice_to_org_id,hdr_invoice_to_org_id_tab(i)),
6802: ship_to_org_id = decode(hdr_ship_to_org_id_tab(i),null,ship_to_org_id,hdr_ship_to_org_id_tab(i)),
6803: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),