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

Line 7371: -- OE_BLANKET_LINES_ALL L

7367: RA_CUSTOMER_MERGES M3,
7368: RA_CUSTOMER_MERGES M4,
7369: RA_CUSTOMER_MERGES M5,
7370: -- changed for bug 3196900
7371: -- OE_BLANKET_LINES_ALL L
7372: OE_BLANKET_LINES L
7373: WHERE
7374: ( l.sold_to_org_id = m1.duplicate_id(+)
7375: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 7372: OE_BLANKET_LINES L

7368: RA_CUSTOMER_MERGES M4,
7369: RA_CUSTOMER_MERGES M5,
7370: -- changed for bug 3196900
7371: -- OE_BLANKET_LINES_ALL L
7372: OE_BLANKET_LINES L
7373: WHERE
7374: ( l.sold_to_org_id = m1.duplicate_id(+)
7375: and l.invoice_to_org_id = m2.duplicate_site_id(+)
7376: and l.ship_to_org_id = m3.duplicate_site_id(+)

Line 7423: -- OE_BLANKET_LINES_ALL L

7419: RA_CUSTOMER_MERGES M3,
7420: RA_CUSTOMER_MERGES M4,
7421: RA_CUSTOMER_MERGES M5,
7422: --changed for bug 3196900
7423: -- OE_BLANKET_LINES_ALL L
7424: OE_BLANKET_LINES L
7425: WHERE
7426: ( l.sold_to_org_id = m1.duplicate_id(+)
7427: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 7424: OE_BLANKET_LINES L

7420: RA_CUSTOMER_MERGES M4,
7421: RA_CUSTOMER_MERGES M5,
7422: --changed for bug 3196900
7423: -- OE_BLANKET_LINES_ALL L
7424: OE_BLANKET_LINES L
7425: WHERE
7426: ( l.sold_to_org_id = m1.duplicate_id(+)
7427: and l.invoice_to_org_id = m2.duplicate_site_id(+)
7428: and l.ship_to_org_id = m3.duplicate_site_id(+)

Line 7461: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES L

7457: INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID,
7458: INTMED_SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID,
7459: M1.CUSTOMER_MERGE_ID
7460: FROM
7461: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES L
7462: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
7463: AND M1.PROCESS_FLAG='N'
7464: AND M1.REQUEST_ID = req_id
7465: AND M1.SET_NUMBER = set_num

Line 7473: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L

7469: INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID,
7470: INTMED_SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID,
7471: M1.CUSTOMER_MERGE_ID
7472: FROM
7473: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L
7474: WHERE L.INVOICE_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7475: AND M1.PROCESS_FLAG='N'
7476: AND M1.REQUEST_ID = req_id
7477: AND M1.SET_NUMBER = set_num

Line 7485: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L

7481: INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID,
7482: INTMED_SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID,
7483: M1.CUSTOMER_MERGE_ID
7484: FROM
7485: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L
7486: WHERE L.SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7487: AND M1.PROCESS_FLAG='N'
7488: AND M1.REQUEST_ID = req_id
7489: AND M1.SET_NUMBER = set_num

Line 7497: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L

7493: INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID,
7494: INTMED_SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID,
7495: M1.CUSTOMER_MERGE_ID
7496: FROM
7497: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L
7498: WHERE L.INTMED_SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7499: AND M1.PROCESS_FLAG='N'
7500: AND M1.REQUEST_ID = req_id
7501: AND M1.SET_NUMBER = set_num

Line 7509: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L

7505: INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID,
7506: INTMED_SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID,
7507: M1.CUSTOMER_MERGE_ID
7508: FROM
7509: RA_CUSTOMER_MERGES M1, OE_BLANKET_LINES L
7510: WHERE L.DELIVER_TO_ORG_ID= M1.DUPLICATE_SITE_ID
7511: AND M1.PROCESS_FLAG='N'
7512: AND M1.REQUEST_ID = req_id
7513: AND M1.SET_NUMBER = set_num;

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

7540:
7541: IF (process_mode = 'LOCK') THEN
7542:
7543: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
7544: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );
7545:
7546: open merge_lines;
7547: close merge_lines;
7548:

Line 7664: 'OE_BLANKET_LINES_ALL',

7660: LAST_UPDATE_DATE,
7661: LAST_UPDATED_BY
7662: ) VALUES (
7663: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7664: 'OE_BLANKET_LINES_ALL',
7665: MERGE_HEADER_ID_LIST(I),
7666: line_line_id_tab(I),
7667: line_sold_to_org_id_tab(I),
7668: 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 7688: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );

7684: end if;
7685: end if;
7686:
7687: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7688: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );
7689:
7690: IF line_line_id_tab.COUNT <> 0 THEN
7691: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
7692: UPDATE OE_BLANKET_LINES_ALL L

Line 7692: UPDATE OE_BLANKET_LINES_ALL L

7688: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_lines_all', FALSE );
7689:
7690: IF line_line_id_tab.COUNT <> 0 THEN
7691: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
7692: UPDATE OE_BLANKET_LINES_ALL L
7693: 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)),
7694: invoice_to_org_id = decode(line_invoice_to_org_id_tab(i),null,invoice_to_org_id,line_invoice_to_org_id_tab(i)),
7695: ship_to_org_id = decode(line_ship_to_org_id_tab(i),null,ship_to_org_id,line_ship_to_org_id_tab(i)),
7696: 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 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)),