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_HIST

Line 7029: -- OE_BLANKET_LINES_HIST L

7025: RA_CUSTOMER_MERGES M3,
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(+)

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 7086: -- OE_BLANKET_LINES_HIST L

7082: RA_CUSTOMER_MERGES M3,
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(+)

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(+)

Line 7147: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );

7143:
7144: IF (process_mode = 'LOCK') THEN
7145:
7146: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
7147: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );
7148:
7149: open merge_lines_history;
7150: close merge_lines_history;
7151:

Line 7245: 'OE_BLANKET_LINES_HIST',

7241: LAST_UPDATE_DATE,
7242: LAST_UPDATED_BY
7243: ) VALUES (
7244: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7245: 'OE_BLANKET_LINES_HIST',
7246: MERGE_HEADER_ID_LIST(I),
7247: lhst_line_id_tab(I),
7248: lhst_version_number_tab(I),
7249: lhst_sold_to_org_id_tab(I),

Line 7270: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );

7266: end if;
7267: end if;
7268:
7269: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7270: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );
7271:
7272: IF lhst_line_id_tab.COUNT <> 0 THEN
7273: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
7274: UPDATE OE_BLANKET_LINES_HIST LHIST

Line 7274: UPDATE OE_BLANKET_LINES_HIST LHIST

7270: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );
7271:
7272: IF lhst_line_id_tab.COUNT <> 0 THEN
7273: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
7274: UPDATE OE_BLANKET_LINES_HIST LHIST
7275: SET sold_to_org_id = decode(lhst_sold_to_org_id_tab(i),null,sold_to_org_id,lhst_sold_to_org_id_tab(i)),
7276: invoice_to_org_id = decode(lhst_invoice_to_org_id_tab(i),null,invoice_to_org_id,lhst_invoice_to_org_id_tab(i)),
7277: ship_to_org_id = decode(lhst_ship_to_org_id_tab(i),null,ship_to_org_id,lhst_ship_to_org_id_tab(i)),
7278: intmed_ship_to_org_id = decode(lhst_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,lhst_intmed_ship_to_org_id_tab(i)),