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 6208: from oe_blanket_headers_hist hist,oe_blanket_headers h

6204: IS
6205: CURSOR c1 is
6206: --changed for bug 3196900
6207: select hist.HEADER_ID
6208: from oe_blanket_headers_hist hist,oe_blanket_headers h
6209: where hist.ship_to_org_id in
6210: (select m.duplicate_site_id
6211: from ra_customer_merges m
6212: where m.process_flag = 'N'

Line 6223: from oe_blanket_headers_hist hist,oe_blanket_headers h

6219:
6220: CURSOR c2 is
6221: --changed for bug 3196900
6222: select hist.HEADER_ID
6223: from oe_blanket_headers_hist hist,oe_blanket_headers h
6224: where hist.invoice_to_org_id in
6225: (select m.duplicate_site_id
6226: from ra_customer_merges m
6227: where m.process_flag = 'N'

Line 6238: from oe_blanket_headers_hist hist, oe_blanket_headers h

6234:
6235: CURSOR c3 is
6236: --changed for bug 3196900
6237: select hist.HEADER_ID
6238: from oe_blanket_headers_hist hist, oe_blanket_headers h
6239: where hist.deliver_to_org_id in
6240: (select m.duplicate_site_id
6241: from ra_customer_merges m
6242: where m.process_flag = 'N'

Line 6253: from oe_blanket_headers_hist hist, oe_blanket_headers h

6249:
6250: CURSOR c4 is
6251: --changed for bug 3196900
6252: select hist.HEADER_ID
6253: from oe_blanket_headers_hist hist, oe_blanket_headers h
6254: where hist.sold_to_org_id in
6255: (select m.duplicate_id
6256: from ra_customer_merges m
6257: where m.process_flag = 'N'

Line 6267: from oe_blanket_headers_hist hist,oe_blanket_headers h

6263:
6264: CURSOR c5 is
6265: --changed for bug 3196900
6266: select hist.HEADER_ID
6267: from oe_blanket_headers_hist hist,oe_blanket_headers h
6268: where hist.sold_to_site_use_id in
6269: (select m.duplicate_id
6270: from ra_customer_merges m
6271: where m.process_flag = 'N'

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

6284:
6285: IF( process_mode = 'LOCK' ) THEN
6286:
6287: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6288: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6289:
6290: open c1;
6291: close c1;
6292:

Line 6329: 'OE_BLANKET_HEADERS_HIST',

6325: LAST_UPDATED_BY
6326: )
6327: select
6328: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6329: 'OE_BLANKET_HEADERS_HIST',
6330: m.customer_merge_header_id,
6331: h.header_id,
6332: h.version_number,
6333: h.ship_to_org_id,

Line 6342: from oe_blanket_headers_hist h,

6338: hz_utility_pub.CREATION_DATE,
6339: hz_utility_pub.LAST_UPDATE_LOGIN,
6340: hz_utility_pub.LAST_UPDATE_DATE,
6341: hz_utility_pub.LAST_UPDATED_BY
6342: from oe_blanket_headers_hist h,
6343: ra_customer_merges m
6344: where h.ship_to_org_id=m.duplicate_site_id
6345: and m.process_flag = 'N'
6346: and m.request_id = req_id

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

6348: end if;
6349:
6350: -- site level update
6351: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6352: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6353:
6354: UPDATE oe_blanket_headers_hist a
6355: set ship_to_org_id = (select distinct m.customer_site_id
6356: from ra_customer_merges m

Line 6354: UPDATE oe_blanket_headers_hist a

6350: -- site level update
6351: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6352: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6353:
6354: UPDATE oe_blanket_headers_hist a
6355: set ship_to_org_id = (select distinct m.customer_site_id
6356: from ra_customer_merges m
6357: where a.ship_to_org_id = m.duplicate_site_id
6358: and m.request_id = req_id

Line 6396: 'OE_BLANKET_HEADERS_HIST',

6392: LAST_UPDATED_BY
6393: )
6394: select
6395: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6396: 'OE_BLANKET_HEADERS_HIST',
6397: m.CUSTOMER_MERGE_HEADER_ID,
6398: h.version_number,
6399: h.header_id,
6400: h.invoice_to_org_id,

Line 6409: from oe_blanket_headers_hist h,

6405: hz_utility_pub.CREATION_DATE,
6406: hz_utility_pub.LAST_UPDATE_LOGIN,
6407: hz_utility_pub.LAST_UPDATE_DATE,
6408: hz_utility_pub.LAST_UPDATED_BY
6409: from oe_blanket_headers_hist h,
6410: ra_customer_merges m
6411: where h.invoice_to_org_id=m.duplicate_site_id
6412: and m.process_flag = 'N'
6413: and m.request_id = req_id

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

6414: and m.set_number = set_num;
6415: end if;
6416:
6417: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6418: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6419:
6420: UPDATE oe_blanket_headers_hist a
6421: set invoice_to_org_id = (select distinct m.customer_site_id
6422: from ra_customer_merges m

Line 6420: UPDATE oe_blanket_headers_hist a

6416:
6417: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6418: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6419:
6420: UPDATE oe_blanket_headers_hist a
6421: set invoice_to_org_id = (select distinct m.customer_site_id
6422: from ra_customer_merges m
6423: where a.invoice_to_org_id = m.duplicate_site_id
6424: and m.request_id = req_id

Line 6463: 'OE_BLANKET_HEADERS_HIST',

6459: LAST_UPDATED_BY
6460: )
6461: select
6462: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6463: 'OE_BLANKET_HEADERS_HIST',
6464: m.CUSTOMER_MERGE_HEADER_ID,
6465: h.header_id,
6466: h.version_number,
6467: h.deliver_to_org_id,

Line 6476: from oe_blanket_headers_hist h,

6472: hz_utility_pub.CREATION_DATE,
6473: hz_utility_pub.LAST_UPDATE_LOGIN,
6474: hz_utility_pub.LAST_UPDATE_DATE,
6475: hz_utility_pub.LAST_UPDATED_BY
6476: from oe_blanket_headers_hist h,
6477: ra_customer_merges m
6478: where h.deliver_to_org_id=m.duplicate_site_id
6479: and m.process_flag = 'N'
6480: and m.request_id = req_id

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

6480: and m.request_id = req_id
6481: and m.set_number = set_num;
6482: end if;
6483: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6484: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6485:
6486: UPDATE oe_blanket_headers_hist a
6487: set deliver_to_org_id = (select distinct m.customer_site_id
6488: from ra_customer_merges m

Line 6486: UPDATE oe_blanket_headers_hist a

6482: end if;
6483: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6484: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6485:
6486: UPDATE oe_blanket_headers_hist a
6487: set deliver_to_org_id = (select distinct m.customer_site_id
6488: from ra_customer_merges m
6489: where a.deliver_to_org_id = m.duplicate_site_id
6490: and m.request_id = req_id

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

6506: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
6507: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
6508:
6509: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6510: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6511:
6512:
6513: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6514: insert into HZ_CUSTOMER_MERGE_LOG (

Line 6532: 'OE_BLANKET_HEADERS_HIST',

6528: LAST_UPDATED_BY
6529: )
6530: select
6531: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6532: 'OE_BLANKET_HEADERS_HIST',
6533: m.customer_merge_header_id,
6534: h.header_id,
6535: h.version_number,
6536: h.sold_to_org_id,

Line 6545: from oe_blanket_headers_hist h,

6541: hz_utility_pub.CREATION_DATE,
6542: hz_utility_pub.LAST_UPDATE_LOGIN,
6543: hz_utility_pub.LAST_UPDATE_DATE,
6544: hz_utility_pub.LAST_UPDATED_BY
6545: from oe_blanket_headers_hist h,
6546: ra_customer_merges m
6547: where h.sold_to_org_id=m.duplicate_site_id
6548: and m.process_flag = 'N'
6549: and m.request_id = req_id

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

6551: end if;
6552: -- customer level update --
6553:
6554: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6555: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6556:
6557: UPDATE oe_blanket_headers_hist a
6558: set sold_to_org_id = (select distinct m.customer_id
6559: from ra_customer_merges m

Line 6557: UPDATE oe_blanket_headers_hist a

6553:
6554: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6555: arp_message.set_token( 'TABLE_NAME', 'oe_blanket_headers_hist', FALSE );
6556:
6557: UPDATE oe_blanket_headers_hist a
6558: set sold_to_org_id = (select distinct m.customer_id
6559: from ra_customer_merges m
6560: where a.sold_to_org_id = m.duplicate_id
6561: and m.process_flag = 'N'

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

6579: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
6580: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
6581:
6582: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6583: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
6584:
6585:
6586: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6587: insert into HZ_CUSTOMER_MERGE_LOG (

Line 6605: 'OE_BLANKET_HEADERS_HIST',

6601: LAST_UPDATED_BY
6602: )
6603: select
6604: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6605: 'OE_BLANKET_HEADERS_HIST',
6606: m.customer_merge_header_id,
6607: h.header_id,
6608: h.version_number,
6609: h.sold_to_site_use_id,

Line 6618: from oe_blanket_headers_hist h,

6614: hz_utility_pub.CREATION_DATE,
6615: hz_utility_pub.LAST_UPDATE_LOGIN,
6616: hz_utility_pub.LAST_UPDATE_DATE,
6617: hz_utility_pub.LAST_UPDATED_BY
6618: from oe_blanket_headers_hist h,
6619: ra_customer_merges m
6620: where h.sold_to_org_id=m.duplicate_site_id
6621: and m.process_flag = 'N'
6622: and m.request_id = req_id

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

6624: end if;
6625: -- customer level update --
6626:
6627: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6628: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
6629:
6630: UPDATE oe_blanket_headers_hist a
6631: set sold_to_site_use_id = (select distinct m.customer_id
6632: from ra_customer_merges m

Line 6630: UPDATE oe_blanket_headers_hist a

6626:
6627: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6628: arp_message.set_token( 'TABLE_NAME', 'OE_BLANKET_HEADERS_HIST', FALSE );
6629:
6630: UPDATE oe_blanket_headers_hist a
6631: set sold_to_site_use_id = (select distinct m.customer_id
6632: from ra_customer_merges m
6633: where a.sold_to_site_use_id = m.duplicate_id
6634: and m.process_flag = 'N'