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 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 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 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 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 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