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_LINES_ALL

Line 6702: -- OE_BLANKET_LINES_ALL L

6698: RA_CUSTOMER_MERGES M3,
6699: RA_CUSTOMER_MERGES M4,
6700: RA_CUSTOMER_MERGES M5,
6701: -- changed for bug 3196900
6702: -- OE_BLANKET_LINES_ALL L
6703: OE_BLANKET_LINES L
6704: WHERE
6705: ( l.sold_to_org_id = m1.duplicate_id(+)
6706: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 6754: -- OE_BLANKET_LINES_ALL L

6750: RA_CUSTOMER_MERGES M3,
6751: RA_CUSTOMER_MERGES M4,
6752: RA_CUSTOMER_MERGES M5,
6753: --changed for bug 3196900
6754: -- OE_BLANKET_LINES_ALL L
6755: OE_BLANKET_LINES L
6756: WHERE
6757: ( l.sold_to_org_id = m1.duplicate_id(+)
6758: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 6812: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );

6808:
6809: IF (process_mode = 'LOCK') THEN
6810:
6811: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6812: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );
6813:
6814: open merge_lines;
6815: close merge_lines;
6816:

Line 6908: 'OE_BLANKET_LINES_ALL',

6904: LAST_UPDATE_DATE,
6905: LAST_UPDATED_BY
6906: ) VALUES (
6907: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6908: 'OE_BLANKET_LINES_ALL',
6909: MERGE_HEADER_ID_LIST(I),
6910: line_line_id_tab(I),
6911: line_sold_to_org_id_tab(I),
6912: decode(line_sold_to_org_id_tab(I),NULL,old_line_sold_to_org_id_tab(I),line_sold_to_org_id_tab(i)),

Line 6932: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );

6928: end if;
6929: end if;
6930:
6931: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6932: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );
6933:
6934: IF line_line_id_tab.COUNT <> 0 THEN
6935: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
6936: UPDATE OE_BLANKET_LINES_ALL L

Line 6936: UPDATE OE_BLANKET_LINES_ALL L

6932: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );
6933:
6934: IF line_line_id_tab.COUNT <> 0 THEN
6935: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
6936: UPDATE OE_BLANKET_LINES_ALL L
6937: SET sold_to_org_id = decode(line_sold_to_org_id_tab(i),null,sold_to_org_id,line_sold_to_org_id_tab(i)),
6938: invoice_to_org_id = decode(line_invoice_to_org_id_tab(i),null,invoice_to_org_id,line_invoice_to_org_id_tab(i)),
6939: ship_to_org_id = decode(line_ship_to_org_id_tab(i),null,ship_to_org_id,line_ship_to_org_id_tab(i)),
6940: intmed_ship_to_org_id = decode(line_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,line_intmed_ship_to_org_id_tab(i)),

Line 7030: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_ALL LN

7026: RA_CUSTOMER_MERGES M4,
7027: RA_CUSTOMER_MERGES M5,
7028: --changed for bug 3196900
7029: -- OE_BLANKET_LINES_HIST L
7030: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_ALL LN
7031: -- Changed for MOAC
7032: WHERE
7033: ( l.sold_to_org_id = m1.duplicate_id(+)
7034: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 7087: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7083: RA_CUSTOMER_MERGES M4,
7084: RA_CUSTOMER_MERGES M5,
7085: --changed for bug 3196900
7086: -- OE_BLANKET_LINES_HIST L
7087: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7088: -- Changed for MOAC
7089: WHERE
7090: ( l.sold_to_org_id = m1.duplicate_id(+)
7091: and l.invoice_to_org_id = m2.duplicate_site_id(+)