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_DATA_FIX dependencies on OE_ORDER_LINES_HISTORY

Line 1251: from oe_order_lines_history

1247: Process_Mode IN VARCHAR2)
1248: IS
1249: CURSOR c1 is
1250: select line_id
1251: from oe_order_lines_history
1252: where ship_to_org_id in
1253: (select m.duplicate_site_id
1254: from ra_customer_merges m
1255: where m.process_flag = 'Y'

Line 1263: from oe_order_lines_history

1259:
1260:
1261: CURSOR c2 is
1262: select line_id
1263: from oe_order_lines_history
1264: where invoice_to_org_id in
1265: (select m.duplicate_site_id
1266: from ra_customer_merges m
1267: where m.process_flag = 'Y'

Line 1275: from oe_order_lines_history

1271:
1272:
1273: CURSOR c3 is
1274: select line_id
1275: from oe_order_lines_history
1276: where deliver_to_org_id in
1277: (select m.duplicate_site_id
1278: from ra_customer_merges m
1279: where m.process_flag = 'Y'

Line 1287: from oe_order_lines_history

1283:
1284:
1285: CURSOR c4 is
1286: select line_id
1287: from oe_order_lines_history
1288: where intmed_ship_to_org_id in
1289: (select m.duplicate_site_id
1290: from ra_customer_merges m
1291: where m.process_flag = 'Y'

Line 1298: from oe_order_lines_history

1294: for update nowait;
1295:
1296: CURSOR c5 is
1297: select line_id
1298: from oe_order_lines_history
1299: where sold_to_org_id in
1300: (select m.duplicate_id
1301: from ra_customer_merges m
1302: where m.process_flag = 'Y'

Line 1321: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

1317:
1318: IF( process_mode = 'LOCK' ) THEN
1319:
1320: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1321: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1322: IF l_debug_level > 0 THEN
1323: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_LINES_HISTORY' ) ;
1324: END IF;
1325:

Line 1323: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_LINES_HISTORY' ) ;

1319:
1320: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1321: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1322: IF l_debug_level > 0 THEN
1323: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_LINES_HISTORY' ) ;
1324: END IF;
1325:
1326: open c1;
1327: close c1;

Line 1348: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

1344: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
1345: END IF;
1346:
1347: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1348: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SHIP_TO_ORG_ID' ) ;
1351: END IF;
1352:

Line 1350: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SHIP_TO_ORG_ID' ) ;

1346:
1347: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1348: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SHIP_TO_ORG_ID' ) ;
1351: END IF;
1352:
1353: UPDATE oe_order_lines_history a
1354: set ship_to_org_id = (select distinct m.customer_site_id

Line 1353: UPDATE oe_order_lines_history a

1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SHIP_TO_ORG_ID' ) ;
1351: END IF;
1352:
1353: UPDATE oe_order_lines_history a
1354: set ship_to_org_id = (select distinct m.customer_site_id
1355: from ra_customer_merges m
1356: where a.ship_to_org_id = m.duplicate_site_id
1357: and m.request_id = req_id

Line 1380: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

1376: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1377: END IF;
1378:
1379: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1380: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1381: IF l_debug_level > 0 THEN
1382: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INVOICE_TO_ORG_ID' ) ;
1383: END IF;
1384:

Line 1382: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INVOICE_TO_ORG_ID' ) ;

1378:
1379: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1380: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1381: IF l_debug_level > 0 THEN
1382: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INVOICE_TO_ORG_ID' ) ;
1383: END IF;
1384:
1385: UPDATE oe_order_lines_history a
1386: set invoice_to_org_id = (select distinct m.customer_site_id

Line 1385: UPDATE oe_order_lines_history a

1381: IF l_debug_level > 0 THEN
1382: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INVOICE_TO_ORG_ID' ) ;
1383: END IF;
1384:
1385: UPDATE oe_order_lines_history a
1386: set invoice_to_org_id = (select distinct m.customer_site_id
1387: from ra_customer_merges m
1388: where a.invoice_to_org_id = m.duplicate_site_id
1389: and m.request_id = req_id

Line 1412: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

1408: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1409: END IF;
1410:
1411: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1412: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.DELIVER_TO_ORG_ID' ) ;
1415: END IF;
1416:

Line 1414: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.DELIVER_TO_ORG_ID' ) ;

1410:
1411: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1412: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.DELIVER_TO_ORG_ID' ) ;
1415: END IF;
1416:
1417: UPDATE oe_order_lines_history a
1418: set deliver_to_org_id = (select distinct m.customer_site_id

Line 1417: UPDATE oe_order_lines_history a

1413: IF l_debug_level > 0 THEN
1414: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.DELIVER_TO_ORG_ID' ) ;
1415: END IF;
1416:
1417: UPDATE oe_order_lines_history a
1418: set deliver_to_org_id = (select distinct m.customer_site_id
1419: from ra_customer_merges m
1420: where a.deliver_to_org_id = m.duplicate_site_id
1421: and m.request_id = req_id

Line 1444: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

1440: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1441: END IF;
1442:
1443: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1444: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1445: IF l_debug_level > 0 THEN
1446: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INTMED_TO_ORG_ID' ) ;
1447: END IF;
1448:

Line 1446: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INTMED_TO_ORG_ID' ) ;

1442:
1443: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1444: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1445: IF l_debug_level > 0 THEN
1446: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INTMED_TO_ORG_ID' ) ;
1447: END IF;
1448:
1449:
1450: UPDATE oe_order_lines_history a

Line 1450: UPDATE oe_order_lines_history a

1446: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.INTMED_TO_ORG_ID' ) ;
1447: END IF;
1448:
1449:
1450: UPDATE oe_order_lines_history a
1451: set intmed_ship_to_org_id = (select distinct m.customer_site_id
1452: from ra_customer_merges m
1453: where a.intmed_ship_to_org_id = m.duplicate_site_id
1454: and m.request_id = req_id

Line 1477: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

1473: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1474: END IF;
1475:
1476: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1477: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1478:
1479:
1480: /* customer level update */
1481: IF l_debug_level > 0 THEN

Line 1485: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

1481: IF l_debug_level > 0 THEN
1482: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
1483: END IF;
1484: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1485: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1486: IF l_debug_level > 0 THEN
1487: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SOLD_TO_ORG_ID' ) ;
1488: END IF;
1489:

Line 1487: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SOLD_TO_ORG_ID' ) ;

1483: END IF;
1484: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1485: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
1486: IF l_debug_level > 0 THEN
1487: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SOLD_TO_ORG_ID' ) ;
1488: END IF;
1489:
1490: UPDATE oe_order_lines_history a
1491: set sold_to_org_id = (select distinct m.customer_id

Line 1490: UPDATE oe_order_lines_history a

1486: IF l_debug_level > 0 THEN
1487: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_HISTORY.SOLD_TO_ORG_ID' ) ;
1488: END IF;
1489:
1490: UPDATE oe_order_lines_history a
1491: set sold_to_org_id = (select distinct m.customer_id
1492: from ra_customer_merges m
1493: where a.sold_to_org_id = m.duplicate_id
1494: and m.process_flag = 'Y'