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_ALL

Line 957: from oe_order_lines_all

953: Process_Mode IN VARCHAR2)
954: IS
955: CURSOR c1 is
956: select line_id
957: from oe_order_lines_all
958: where ship_to_org_id in
959: (select m.duplicate_site_id
960: from ra_customer_merges m
961: where m.process_flag = 'Y'

Line 969: from oe_order_lines_all

965:
966:
967: CURSOR c2 is
968: select line_id
969: from oe_order_lines_all
970: where invoice_to_org_id in
971: (select m.duplicate_site_id
972: from ra_customer_merges m
973: where m.process_flag = 'Y'

Line 981: from oe_order_lines_all

977:
978:
979: CURSOR c3 is
980: select line_id
981: from oe_order_lines_all
982: where deliver_to_org_id in
983: (select m.duplicate_site_id
984: from ra_customer_merges m
985: where m.process_flag = 'Y'

Line 993: from oe_order_lines_all

989:
990:
991: CURSOR c4 is
992: select line_id
993: from oe_order_lines_all
994: where intmed_ship_to_org_id in
995: (select m.duplicate_site_id
996: from ra_customer_merges m
997: where m.process_flag = 'Y'

Line 1004: from oe_order_lines_all

1000: for update nowait;
1001:
1002: CURSOR c5 is
1003: select line_id
1004: from oe_order_lines_all
1005: where sold_to_org_id in
1006: (select m.duplicate_id
1007: from ra_customer_merges m
1008: where m.process_flag = 'Y'

Line 1027: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

1023:
1024: IF( process_mode = 'LOCK' ) THEN
1025:
1026: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1027: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_LINES_ALL' ) ;
1030: END IF;
1031:

Line 1029: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_LINES_ALL' ) ;

1025:
1026: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1027: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'LOCKING TABLE OE_ORDER_LINES_ALL' ) ;
1030: END IF;
1031:
1032: open c1;
1033: close c1;

Line 1054: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

1050: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
1051: END IF;
1052:
1053: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1054: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1055: IF l_debug_level > 0 THEN
1056: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SHIP_TO_ORG_ID' ) ;
1057: END IF;
1058:

Line 1056: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SHIP_TO_ORG_ID' ) ;

1052:
1053: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1054: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1055: IF l_debug_level > 0 THEN
1056: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SHIP_TO_ORG_ID' ) ;
1057: END IF;
1058:
1059: UPDATE oe_order_lines_all a
1060: set ship_to_org_id = (select distinct m.customer_site_id

Line 1059: UPDATE oe_order_lines_all a

1055: IF l_debug_level > 0 THEN
1056: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SHIP_TO_ORG_ID' ) ;
1057: END IF;
1058:
1059: UPDATE oe_order_lines_all a
1060: set ship_to_org_id = (select distinct m.customer_site_id
1061: from ra_customer_merges m
1062: where a.ship_to_org_id = m.duplicate_site_id
1063: and m.request_id = req_id

Line 1085: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1083: END IF;
1084: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1085: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1086: IF l_debug_level > 0 THEN
1087: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INVOICE_TO_ORG_ID' ) ;
1088: END IF;
1089:

Line 1087: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INVOICE_TO_ORG_ID' ) ;

1083: END IF;
1084: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1085: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1086: IF l_debug_level > 0 THEN
1087: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INVOICE_TO_ORG_ID' ) ;
1088: END IF;
1089:
1090: UPDATE oe_order_lines_all a
1091: set invoice_to_org_id = (select distinct m.customer_site_id

Line 1090: UPDATE oe_order_lines_all a

1086: IF l_debug_level > 0 THEN
1087: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INVOICE_TO_ORG_ID' ) ;
1088: END IF;
1089:
1090: UPDATE oe_order_lines_all a
1091: set invoice_to_org_id = (select distinct m.customer_site_id
1092: from ra_customer_merges m
1093: where a.invoice_to_org_id = m.duplicate_site_id
1094: and m.request_id = req_id

Line 1117: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

1113: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1114: END IF;
1115:
1116: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1117: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1118: IF l_debug_level > 0 THEN
1119: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.DELIVER_TO_ORG_ID' ) ;
1120: END IF;
1121:

Line 1119: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.DELIVER_TO_ORG_ID' ) ;

1115:
1116: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1117: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1118: IF l_debug_level > 0 THEN
1119: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.DELIVER_TO_ORG_ID' ) ;
1120: END IF;
1121:
1122: UPDATE oe_order_lines_all a
1123: set deliver_to_org_id = (select distinct m.customer_site_id

Line 1122: UPDATE oe_order_lines_all a

1118: IF l_debug_level > 0 THEN
1119: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.DELIVER_TO_ORG_ID' ) ;
1120: END IF;
1121:
1122: UPDATE oe_order_lines_all a
1123: set deliver_to_org_id = (select distinct m.customer_site_id
1124: from ra_customer_merges m
1125: where a.deliver_to_org_id = m.duplicate_site_id
1126: and m.request_id = req_id

Line 1149: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

1145: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1146: END IF;
1147:
1148: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1149: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1150: IF l_debug_level > 0 THEN
1151: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INTMED_TO_ORG_ID' ) ;
1152: END IF;
1153:

Line 1151: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INTMED_TO_ORG_ID' ) ;

1147:
1148: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1149: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1150: IF l_debug_level > 0 THEN
1151: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INTMED_TO_ORG_ID' ) ;
1152: END IF;
1153:
1154: UPDATE oe_order_lines_all a
1155: set intmed_ship_to_org_id = (select distinct m.customer_site_id

Line 1154: UPDATE oe_order_lines_all a

1150: IF l_debug_level > 0 THEN
1151: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.INTMED_TO_ORG_ID' ) ;
1152: END IF;
1153:
1154: UPDATE oe_order_lines_all a
1155: set intmed_ship_to_org_id = (select distinct m.customer_site_id
1156: from ra_customer_merges m
1157: where a.intmed_ship_to_org_id = m.duplicate_site_id
1158: and m.request_id = req_id

Line 1181: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

1177: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1178: END IF;
1179:
1180: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1181: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1182:
1183: /* customer level update */
1184: IF l_debug_level > 0 THEN
1185: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;

Line 1188: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

1184: IF l_debug_level > 0 THEN
1185: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
1186: END IF;
1187: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1188: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SOLD_TO_ORG_ID' ) ;
1191: END IF;
1192:

Line 1190: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SOLD_TO_ORG_ID' ) ;

1186: END IF;
1187: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1188: -- arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SOLD_TO_ORG_ID' ) ;
1191: END IF;
1192:
1193: UPDATE oe_order_lines_all a
1194: set sold_to_org_id = (select distinct m.customer_id

Line 1193: UPDATE oe_order_lines_all a

1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'UPDATING OE_ORDER_LINES_ALL.SOLD_TO_ORG_ID' ) ;
1191: END IF;
1192:
1193: UPDATE oe_order_lines_all a
1194: set sold_to_org_id = (select distinct m.customer_id
1195: from ra_customer_merges m
1196: where a.sold_to_org_id = m.duplicate_id
1197: and m.process_flag = 'Y'