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_HEADERS

Line 6484: -- OE_BLANKET_HEADERS_ALL H

6480: RA_CUSTOMER_MERGES M3,
6481: RA_CUSTOMER_MERGES M4,
6482: RA_CUSTOMER_MERGES M5,
6483: -- changed for bug 3196900
6484: -- OE_BLANKET_HEADERS_ALL H
6485: OE_BLANKET_HEADERS H
6486: WHERE
6487: ( h.sold_to_org_id = m1.duplicate_id(+)
6488: and h.invoice_to_org_id = m2.duplicate_site_id(+)

Line 6485: OE_BLANKET_HEADERS H

6481: RA_CUSTOMER_MERGES M4,
6482: RA_CUSTOMER_MERGES M5,
6483: -- changed for bug 3196900
6484: -- OE_BLANKET_HEADERS_ALL H
6485: OE_BLANKET_HEADERS H
6486: WHERE
6487: ( h.sold_to_org_id = m1.duplicate_id(+)
6488: and h.invoice_to_org_id = m2.duplicate_site_id(+)
6489: and h.ship_to_org_id = m3.duplicate_site_id(+)

Line 6536: -- OE_BLANKET_HEADERS_ALL H

6532: RA_CUSTOMER_MERGES M3,
6533: RA_CUSTOMER_MERGES M4,
6534: RA_CUSTOMER_MERGES M5,
6535: -- changed for bug 3196900
6536: -- OE_BLANKET_HEADERS_ALL H
6537: OE_BLANKET_HEADERS H
6538: WHERE
6539: ( h.sold_to_org_id = m1.duplicate_id(+)
6540: and h.invoice_to_org_id = m2.duplicate_site_id(+)

Line 6537: OE_BLANKET_HEADERS H

6533: RA_CUSTOMER_MERGES M4,
6534: RA_CUSTOMER_MERGES M5,
6535: -- changed for bug 3196900
6536: -- OE_BLANKET_HEADERS_ALL H
6537: OE_BLANKET_HEADERS H
6538: WHERE
6539: ( h.sold_to_org_id = m1.duplicate_id(+)
6540: and h.invoice_to_org_id = m2.duplicate_site_id(+)
6541: and h.ship_to_org_id = m3.duplicate_site_id(+)

Line 6572: OE_CUST_MERGES_GTT M1, OE_BLANKET_HEADERS H

6568: H.HEADER_ID, H.SOLD_TO_ORG_ID, H.INVOICE_TO_ORG_ID,
6569: H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
6570: H.SOLD_TO_SITE_USE_ID, M1.CUSTOMER_MERGE_ID
6571: FROM
6572: OE_CUST_MERGES_GTT M1, OE_BLANKET_HEADERS H
6573: WHERE H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
6574: AND M1.PROCESS_FLAG='N'
6575: AND M1.REQUEST_ID = req_id
6576: AND M1.SET_NUMBER = set_num

Line 6583: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H

6579: H.HEADER_ID, H.SOLD_TO_ORG_ID, H.INVOICE_TO_ORG_ID,
6580: H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
6581: H.SOLD_TO_SITE_USE_ID, M1.CUSTOMER_MERGE_ID
6582: FROM
6583: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H
6584: WHERE H.INVOICE_TO_ORG_ID= M1.DUPLICATE_SITE_ID
6585: AND M1.PROCESS_FLAG='N'
6586: AND M1.REQUEST_ID = req_id
6587: AND M1.SET_NUMBER = set_num

Line 6594: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H

6590: H.HEADER_ID, H.SOLD_TO_ORG_ID, H.INVOICE_TO_ORG_ID,
6591: H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
6592: H.SOLD_TO_SITE_USE_ID, M1.CUSTOMER_MERGE_ID
6593: FROM
6594: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H
6595: WHERE H.SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
6596: AND M1.PROCESS_FLAG='N'
6597: AND M1.REQUEST_ID = req_id
6598: AND M1.SET_NUMBER = set_num

Line 6605: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H

6601: H.HEADER_ID, H.SOLD_TO_ORG_ID, H.INVOICE_TO_ORG_ID,
6602: H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
6603: H.SOLD_TO_SITE_USE_ID, M1.CUSTOMER_MERGE_ID
6604: FROM
6605: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H
6606: WHERE H.SOLD_TO_SITE_USE_ID= M1.DUPLICATE_SITE_ID
6607: AND M1.PROCESS_FLAG='N'
6608: AND M1.REQUEST_ID = req_id
6609: AND M1.SET_NUMBER = set_num

Line 6616: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H

6612: H.HEADER_ID, H.SOLD_TO_ORG_ID, H.INVOICE_TO_ORG_ID,
6613: H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
6614: H.SOLD_TO_SITE_USE_ID, M1.CUSTOMER_MERGE_ID
6615: FROM
6616: RA_CUSTOMER_MERGES M1, OE_BLANKET_HEADERS H
6617: WHERE H.DELIVER_TO_ORG_ID= M1.DUPLICATE_SITE_ID
6618: AND M1.PROCESS_FLAG='N'
6619: AND M1.REQUEST_ID = req_id
6620: AND M1.SET_NUMBER = set_num;

Line 6648: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_ALL', FALSE );

6644:
6645: IF (process_mode = 'LOCK') THEN
6646:
6647: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6648: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_ALL', FALSE );
6649:
6650: open merge_headers;
6651: close merge_headers;
6652:

Line 6767: 'OE_BLANKET_HEADERS_ALL',

6763: LAST_UPDATE_DATE,
6764: LAST_UPDATED_BY
6765: ) VALUES (
6766: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6767: 'OE_BLANKET_HEADERS_ALL',
6768: MERGE_HEADER_ID_LIST(I),
6769: hdr_header_id_tab(I),
6770: old_hdr_sold_to_org_id_tab(I),
6771: decode(hdr_sold_to_org_id_tab(I),NULL,old_hdr_sold_to_org_id_tab(I),hdr_sold_to_org_id_tab(i)),

Line 6794: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_all', FALSE );

6790: end if;
6791:
6792:
6793: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6794: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_all', FALSE );
6795:
6796: IF hdr_header_id_tab.COUNT <> 0 THEN
6797:
6798: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST

Line 6799: UPDATE OE_BLANKET_HEADERS_ALL H

6795:
6796: IF hdr_header_id_tab.COUNT <> 0 THEN
6797:
6798: FORALL i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST
6799: UPDATE OE_BLANKET_HEADERS_ALL H
6800: SET sold_to_org_id = decode(hdr_sold_to_org_id_tab(i),null,sold_to_org_id,hdr_sold_to_org_id_tab(i)),
6801: invoice_to_org_id = decode(hdr_invoice_to_org_id_tab(i),null,invoice_to_org_id,hdr_invoice_to_org_id_tab(i)),
6802: ship_to_org_id = decode(hdr_ship_to_org_id_tab(i),null,ship_to_org_id,hdr_ship_to_org_id_tab(i)),
6803: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),

Line 6877: from oe_blanket_headers_hist hist,oe_blanket_headers h

6873: IS
6874: CURSOR c1 is
6875: --changed for bug 3196900
6876: select hist.HEADER_ID
6877: from oe_blanket_headers_hist hist,oe_blanket_headers h
6878: where hist.ship_to_org_id in
6879: (select m.duplicate_site_id
6880: from ra_customer_merges m
6881: where m.process_flag = 'N'

Line 6892: from oe_blanket_headers_hist hist,oe_blanket_headers h

6888:
6889: CURSOR c2 is
6890: --changed for bug 3196900
6891: select hist.HEADER_ID
6892: from oe_blanket_headers_hist hist,oe_blanket_headers h
6893: where hist.invoice_to_org_id in
6894: (select m.duplicate_site_id
6895: from ra_customer_merges m
6896: where m.process_flag = 'N'

Line 6907: from oe_blanket_headers_hist hist, oe_blanket_headers h

6903:
6904: CURSOR c3 is
6905: --changed for bug 3196900
6906: select hist.HEADER_ID
6907: from oe_blanket_headers_hist hist, oe_blanket_headers h
6908: where hist.deliver_to_org_id in
6909: (select m.duplicate_site_id
6910: from ra_customer_merges m
6911: where m.process_flag = 'N'

Line 6922: from oe_blanket_headers_hist hist, oe_blanket_headers h

6918:
6919: CURSOR c4 is
6920: --changed for bug 3196900
6921: select hist.HEADER_ID
6922: from oe_blanket_headers_hist hist, oe_blanket_headers h
6923: where hist.sold_to_org_id in
6924: (select m.duplicate_id
6925: from ra_customer_merges m
6926: where m.process_flag = 'N'

Line 6936: from oe_blanket_headers_hist hist,oe_blanket_headers h

6932:
6933: CURSOR c5 is
6934: --changed for bug 3196900
6935: select hist.HEADER_ID
6936: from oe_blanket_headers_hist hist,oe_blanket_headers h
6937: where hist.sold_to_site_use_id in
6938: (select m.duplicate_id
6939: from ra_customer_merges m
6940: where m.process_flag = 'N'

Line 6957: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );

6953:
6954: IF( process_mode = 'LOCK' ) THEN
6955:
6956: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6957: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6958:
6959: open c1;
6960: close c1;
6961:

Line 6998: 'OE_BLANKET_HEADERS_HIST',

6994: LAST_UPDATED_BY
6995: )
6996: select
6997: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6998: 'OE_BLANKET_HEADERS_HIST',
6999: m.customer_merge_header_id,
7000: h.header_id,
7001: h.version_number,
7002: h.ship_to_org_id,

Line 7011: from oe_blanket_headers_hist h,

7007: hz_utility_pub.CREATION_DATE,
7008: hz_utility_pub.LAST_UPDATE_LOGIN,
7009: hz_utility_pub.LAST_UPDATE_DATE,
7010: hz_utility_pub.LAST_UPDATED_BY
7011: from oe_blanket_headers_hist h,
7012: ra_customer_merges m
7013: where h.ship_to_org_id=m.duplicate_site_id
7014: and m.process_flag = 'N'
7015: and m.request_id = req_id

Line 7021: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );

7017: end if;
7018:
7019: -- site level update
7020: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7021: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7022:
7023: UPDATE oe_blanket_headers_hist a
7024: set ship_to_org_id = (select distinct m.customer_site_id
7025: from ra_customer_merges m

Line 7023: UPDATE oe_blanket_headers_hist a

7019: -- site level update
7020: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7021: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7022:
7023: UPDATE oe_blanket_headers_hist a
7024: set ship_to_org_id = (select distinct m.customer_site_id
7025: from ra_customer_merges m
7026: where a.ship_to_org_id = m.duplicate_site_id
7027: and m.request_id = req_id

Line 7065: 'OE_BLANKET_HEADERS_HIST',

7061: LAST_UPDATED_BY
7062: )
7063: select
7064: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7065: 'OE_BLANKET_HEADERS_HIST',
7066: m.CUSTOMER_MERGE_HEADER_ID,
7067: h.version_number,
7068: h.header_id,
7069: h.invoice_to_org_id,

Line 7078: from oe_blanket_headers_hist h,

7074: hz_utility_pub.CREATION_DATE,
7075: hz_utility_pub.LAST_UPDATE_LOGIN,
7076: hz_utility_pub.LAST_UPDATE_DATE,
7077: hz_utility_pub.LAST_UPDATED_BY
7078: from oe_blanket_headers_hist h,
7079: ra_customer_merges m
7080: where h.invoice_to_org_id=m.duplicate_site_id
7081: and m.process_flag = 'N'
7082: and m.request_id = req_id

Line 7087: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );

7083: and m.set_number = set_num;
7084: end if;
7085:
7086: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7087: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7088:
7089: UPDATE oe_blanket_headers_hist a
7090: set invoice_to_org_id = (select distinct m.customer_site_id
7091: from ra_customer_merges m

Line 7089: UPDATE oe_blanket_headers_hist a

7085:
7086: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7087: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7088:
7089: UPDATE oe_blanket_headers_hist a
7090: set invoice_to_org_id = (select distinct m.customer_site_id
7091: from ra_customer_merges m
7092: where a.invoice_to_org_id = m.duplicate_site_id
7093: and m.request_id = req_id

Line 7132: 'OE_BLANKET_HEADERS_HIST',

7128: LAST_UPDATED_BY
7129: )
7130: select
7131: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7132: 'OE_BLANKET_HEADERS_HIST',
7133: m.CUSTOMER_MERGE_HEADER_ID,
7134: h.header_id,
7135: h.version_number,
7136: h.deliver_to_org_id,

Line 7145: from oe_blanket_headers_hist h,

7141: hz_utility_pub.CREATION_DATE,
7142: hz_utility_pub.LAST_UPDATE_LOGIN,
7143: hz_utility_pub.LAST_UPDATE_DATE,
7144: hz_utility_pub.LAST_UPDATED_BY
7145: from oe_blanket_headers_hist h,
7146: ra_customer_merges m
7147: where h.deliver_to_org_id=m.duplicate_site_id
7148: and m.process_flag = 'N'
7149: and m.request_id = req_id

Line 7153: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );

7149: and m.request_id = req_id
7150: and m.set_number = set_num;
7151: end if;
7152: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7153: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7154:
7155: UPDATE oe_blanket_headers_hist a
7156: set deliver_to_org_id = (select distinct m.customer_site_id
7157: from ra_customer_merges m

Line 7155: UPDATE oe_blanket_headers_hist a

7151: end if;
7152: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7153: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7154:
7155: UPDATE oe_blanket_headers_hist a
7156: set deliver_to_org_id = (select distinct m.customer_site_id
7157: from ra_customer_merges m
7158: where a.deliver_to_org_id = m.duplicate_site_id
7159: and m.request_id = req_id

Line 7179: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );

7175: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
7176: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
7177:
7178: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7179: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7180:
7181:
7182: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
7183: insert into HZ_CUSTOMER_MERGE_LOG (

Line 7201: 'OE_BLANKET_HEADERS_HIST',

7197: LAST_UPDATED_BY
7198: )
7199: select
7200: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7201: 'OE_BLANKET_HEADERS_HIST',
7202: m.customer_merge_header_id,
7203: h.header_id,
7204: h.version_number,
7205: h.sold_to_org_id,

Line 7214: from oe_blanket_headers_hist h,

7210: hz_utility_pub.CREATION_DATE,
7211: hz_utility_pub.LAST_UPDATE_LOGIN,
7212: hz_utility_pub.LAST_UPDATE_DATE,
7213: hz_utility_pub.LAST_UPDATED_BY
7214: from oe_blanket_headers_hist h,
7215: ra_customer_merges m
7216: where h.sold_to_org_id=m.duplicate_site_id
7217: and m.process_flag = 'N'
7218: and m.request_id = req_id

Line 7224: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );

7220: end if;
7221: -- customer level update --
7222:
7223: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7224: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7225:
7226: UPDATE oe_blanket_headers_hist a
7227: set sold_to_org_id = (select distinct m.customer_id
7228: from ra_customer_merges m

Line 7226: UPDATE oe_blanket_headers_hist a

7222:
7223: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7224: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
7225:
7226: UPDATE oe_blanket_headers_hist a
7227: set sold_to_org_id = (select distinct m.customer_id
7228: from ra_customer_merges m
7229: where a.sold_to_org_id = m.duplicate_id
7230: and m.process_flag = 'N'

Line 7252: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );

7248: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
7249: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
7250:
7251: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7252: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
7253:
7254:
7255: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
7256: insert into HZ_CUSTOMER_MERGE_LOG (

Line 7274: 'OE_BLANKET_HEADERS_HIST',

7270: LAST_UPDATED_BY
7271: )
7272: select
7273: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7274: 'OE_BLANKET_HEADERS_HIST',
7275: m.customer_merge_header_id,
7276: h.header_id,
7277: h.version_number,
7278: h.sold_to_site_use_id,

Line 7287: from oe_blanket_headers_hist h,

7283: hz_utility_pub.CREATION_DATE,
7284: hz_utility_pub.LAST_UPDATE_LOGIN,
7285: hz_utility_pub.LAST_UPDATE_DATE,
7286: hz_utility_pub.LAST_UPDATED_BY
7287: from oe_blanket_headers_hist h,
7288: ra_customer_merges m
7289: where h.sold_to_org_id=m.duplicate_site_id
7290: and m.process_flag = 'N'
7291: and m.request_id = req_id

Line 7297: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );

7293: end if;
7294: -- customer level update --
7295:
7296: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7297: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
7298:
7299: UPDATE oe_blanket_headers_hist a
7300: set sold_to_site_use_id = (select distinct m.customer_id
7301: from ra_customer_merges m

Line 7299: UPDATE oe_blanket_headers_hist a

7295:
7296: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7297: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
7298:
7299: UPDATE oe_blanket_headers_hist a
7300: set sold_to_site_use_id = (select distinct m.customer_id
7301: from ra_customer_merges m
7302: where a.sold_to_site_use_id = m.duplicate_id
7303: and m.process_flag = 'N'