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_HIST

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'