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 5903: -- OE_BLANKET_HEADERS_ALL H

5899: RA_CUSTOMER_MERGES M3,
5900: RA_CUSTOMER_MERGES M4,
5901: RA_CUSTOMER_MERGES M5,
5902: -- changed for bug 3196900
5903: -- OE_BLANKET_HEADERS_ALL H
5904: OE_BLANKET_HEADERS H
5905: WHERE
5906: ( h.sold_to_org_id = m1.duplicate_id(+)
5907: and h.invoice_to_org_id = m2.duplicate_site_id(+)

Line 5955: -- OE_BLANKET_HEADERS_ALL H

5951: RA_CUSTOMER_MERGES M3,
5952: RA_CUSTOMER_MERGES M4,
5953: RA_CUSTOMER_MERGES M5,
5954: -- changed for bug 3196900
5955: -- OE_BLANKET_HEADERS_ALL H
5956: OE_BLANKET_HEADERS H
5957: WHERE
5958: ( h.sold_to_org_id = m1.duplicate_id(+)
5959: and h.invoice_to_org_id = m2.duplicate_site_id(+)

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

6006:
6007: IF (process_mode = 'LOCK') THEN
6008:
6009: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6010: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_ALL', FALSE );
6011:
6012: open merge_headers;
6013: close merge_headers;
6014:

Line 6109: 'OE_BLANKET_HEADERS_ALL',

6105: LAST_UPDATE_DATE,
6106: LAST_UPDATED_BY
6107: ) VALUES (
6108: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6109: 'OE_BLANKET_HEADERS_ALL',
6110: MERGE_HEADER_ID_LIST(I),
6111: hdr_header_id_tab(I),
6112: old_hdr_sold_to_org_id_tab(I),
6113: 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 6136: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_all', FALSE );

6132: end if;
6133:
6134:
6135: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6136: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_all', FALSE );
6137:
6138: IF hdr_header_id_tab.COUNT <> 0 THEN
6139:
6140: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST

Line 6141: UPDATE OE_BLANKET_HEADERS_ALL H

6137:
6138: IF hdr_header_id_tab.COUNT <> 0 THEN
6139:
6140: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST
6141: UPDATE OE_BLANKET_HEADERS_ALL H
6142: 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)),
6143: invoice_to_org_id = decode(hdr_invoice_to_org_id_tab(i),null,invoice_to_org_id,hdr_invoice_to_org_id_tab(i)),
6144: ship_to_org_id = decode(hdr_ship_to_org_id_tab(i),null,ship_to_org_id,hdr_ship_to_org_id_tab(i)),
6145: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),