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

7791: RA_CUSTOMER_MERGES M3,
7792: RA_CUSTOMER_MERGES M4,
7793: RA_CUSTOMER_MERGES M5,
7794: --changed for bug 3196900
7795: -- OE_BLANKET_LINES_HIST L
7796: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_ALL LN
7797: -- Changed for MOAC
7798: WHERE
7799: ( l.sold_to_org_id = m1.duplicate_id(+)

Line 7796: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_ALL LN

7792: RA_CUSTOMER_MERGES M4,
7793: RA_CUSTOMER_MERGES M5,
7794: --changed for bug 3196900
7795: -- OE_BLANKET_LINES_HIST L
7796: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_ALL LN
7797: -- Changed for MOAC
7798: WHERE
7799: ( l.sold_to_org_id = m1.duplicate_id(+)
7800: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 7852: -- OE_BLANKET_LINES_HIST L

7848: RA_CUSTOMER_MERGES M3,
7849: RA_CUSTOMER_MERGES M4,
7850: RA_CUSTOMER_MERGES M5,
7851: --changed for bug 3196900
7852: -- OE_BLANKET_LINES_HIST L
7853: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7854: -- Changed for MOAC
7855: WHERE
7856: ( l.sold_to_org_id = m1.duplicate_id(+)

Line 7853: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7849: RA_CUSTOMER_MERGES M4,
7850: RA_CUSTOMER_MERGES M5,
7851: --changed for bug 3196900
7852: -- OE_BLANKET_LINES_HIST L
7853: OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7854: -- Changed for MOAC
7855: WHERE
7856: ( l.sold_to_org_id = m1.duplicate_id(+)
7857: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 7891: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7887: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID,
7888: L.SHIP_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID,
7889: L.VERSION_NUMBER, M1.CUSTOMER_MERGE_ID
7890: FROM
7891: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7892: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
7893: AND M1.PROCESS_FLAG='N'
7894: AND M1.REQUEST_ID = req_id
7895: AND M1.SET_NUMBER = set_num

Line 7902: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7898: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID,
7899: L.SHIP_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID,
7900: L.VERSION_NUMBER, M1.CUSTOMER_MERGE_ID
7901: FROM
7902: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7903: WHERE L.INVOICE_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7904: AND M1.PROCESS_FLAG='N'
7905: AND M1.REQUEST_ID = req_id
7906: AND M1.SET_NUMBER = set_num

Line 7913: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7909: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID,
7910: L.SHIP_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID,
7911: L.VERSION_NUMBER, M1.CUSTOMER_MERGE_ID
7912: FROM
7913: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7914: WHERE L.SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7915: AND M1.PROCESS_FLAG='N'
7916: AND M1.REQUEST_ID = req_id
7917: AND M1.SET_NUMBER = set_num

Line 7924: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7920: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID,
7921: L.SHIP_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID,
7922: L.VERSION_NUMBER, M1.CUSTOMER_MERGE_ID
7923: FROM
7924: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7925: WHERE L.INTMED_SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7926: AND M1.PROCESS_FLAG='N'
7927: AND M1.REQUEST_ID = req_id
7928: AND M1.SET_NUMBER = set_num

Line 7935: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7931: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID,
7932: L.SHIP_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID,
7933: L.VERSION_NUMBER, M1.CUSTOMER_MERGE_ID
7934: FROM
7935: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7936: WHERE L.DELIVER_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7937: AND M1.PROCESS_FLAG='N'
7938: AND M1.REQUEST_ID = req_id
7939: AND M1.SET_NUMBER = set_num

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

7968:
7969: IF (process_mode = 'LOCK') THEN
7970:
7971: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
7972: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );
7973:
7974: open merge_lines_history;
7975: close merge_lines_history;
7976:

Line 8093: 'OE_BLANKET_LINES_HIST',

8089: LAST_UPDATE_DATE,
8090: LAST_UPDATED_BY
8091: ) VALUES (
8092: HZ_CUSTOMER_MERGE_LOG_s.nextval,
8093: 'OE_BLANKET_LINES_HIST',
8094: MERGE_HEADER_ID_LIST(I),
8095: lhst_line_id_tab(I),
8096: lhst_version_number_tab(I),
8097: lhst_sold_to_org_id_tab(I),

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

8114: end if;
8115: end if;
8116:
8117: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
8118: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );
8119:
8120: IF lhst_line_id_tab.COUNT <> 0 THEN
8121: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
8122: UPDATE OE_BLANKET_LINES_HIST LHIST

Line 8122: UPDATE OE_BLANKET_LINES_HIST LHIST

8118: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_hist', FALSE );
8119:
8120: IF lhst_line_id_tab.COUNT <> 0 THEN
8121: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
8122: UPDATE OE_BLANKET_LINES_HIST LHIST
8123: 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)),
8124: invoice_to_org_id = decode(lhst_invoice_to_org_id_tab(i),null,invoice_to_org_id,lhst_invoice_to_org_id_tab(i)),
8125: ship_to_org_id = decode(lhst_ship_to_org_id_tab(i),null,ship_to_org_id,lhst_ship_to_org_id_tab(i)),
8126: 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)),