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_ORDER_HEADER_HISTORY

Line 664: OE_ORDER_HEADER_HISTORY HIST,

660: RA_CUSTOMER_MERGES M4,
661: RA_CUSTOMER_MERGES M5,
662: RA_CUSTOMER_MERGES M6,
663: RA_CUSTOMER_MERGES M7,
664: OE_ORDER_HEADER_HISTORY HIST,
665: -- Changed by Srini for MOAC
666: -- This MOAC change has been reverted.
667: -- For more information please
668: -- see the bug #5050382

Line 736: OE_ORDER_HEADER_HISTORY HIST,

732: RA_CUSTOMER_MERGES M4,
733: RA_CUSTOMER_MERGES M5,
734: RA_CUSTOMER_MERGES M6,
735: RA_CUSTOMER_MERGES M7,
736: OE_ORDER_HEADER_HISTORY HIST,
737: --Changed for MOAC
738: OE_ORDER_HEADERS_ALL H
739: WHERE
740: ( hist.sold_to_org_id = m1.duplicate_id(+)

Line 785: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

781: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
782: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
783: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
784: FROM
785: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
786: WHERE HIST.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
787: AND M1.PROCESS_FLAG='N'
788: AND M1.REQUEST_ID = req_id
789: AND M1.SET_NUMBER = set_num

Line 797: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

793: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
794: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
795: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
796: FROM
797: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
798: WHERE HIST.INVOICE_TO_ORG_ID= M1.DUPLICATE_SITE_ID
799: AND M1.PROCESS_FLAG='N'
800: AND M1.REQUEST_ID = req_id
801: AND M1.SET_NUMBER = set_num

Line 809: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

805: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
806: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
807: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
808: FROM
809: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
810: WHERE HIST.SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
811: AND M1.PROCESS_FLAG='N'
812: AND M1.REQUEST_ID = req_id
813: AND M1.SET_NUMBER = set_num

Line 821: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

817: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
818: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
819: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
820: FROM
821: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
822: WHERE HIST.SOLD_TO_SITE_USE_ID= M1.DUPLICATE_SITE_ID
823: AND M1.PROCESS_FLAG='N'
824: AND M1.REQUEST_ID = req_id
825: AND M1.SET_NUMBER = set_num

Line 833: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

829: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
830: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
831: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
832: FROM
833: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
834: WHERE HIST.DELIVER_TO_ORG_ID= M1.DUPLICATE_SITE_ID
835: AND M1.PROCESS_FLAG='N'
836: AND M1.REQUEST_ID = req_id
837: AND M1.SET_NUMBER = set_num

Line 845: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

841: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
842: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
843: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
844: FROM
845: RA_CUSTOMER_MERGES M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
846: WHERE HIST.END_CUSTOMER_SITE_USE_ID= M1.DUPLICATE_SITE_ID
847: AND M1.PROCESS_FLAG='N'
848: AND M1.REQUEST_ID = req_id
849: AND M1.SET_NUMBER = set_num

Line 857: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

853: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
854: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
855: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
856: FROM
857: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
858: WHERE HIST.END_CUSTOMER_ID= M1.DUPLICATE_ID
859: AND M1.PROCESS_FLAG='N'
860: AND M1.REQUEST_ID = req_id
861: AND M1.SET_NUMBER = set_num

Line 885: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );

881:
882: IF (process_mode = 'LOCK') THEN
883:
884: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
885: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
886:
887: open merge_headers_history;
888: close merge_headers_history;
889:

Line 981: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );

977: end if;
978:
979:
980: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
981: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
982:
983: IF hhst_header_id_tab.COUNT <> 0 THEN
984: FORALL i in hhst_header_id_tab.FIRST..hhst_header_id_tab.LAST
985: UPDATE OE_ORDER_HEADER_HISTORY HHIST

Line 985: UPDATE OE_ORDER_HEADER_HISTORY HHIST

981: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
982:
983: IF hhst_header_id_tab.COUNT <> 0 THEN
984: FORALL i in hhst_header_id_tab.FIRST..hhst_header_id_tab.LAST
985: UPDATE OE_ORDER_HEADER_HISTORY HHIST
986: SET sold_to_org_id = decode(hhst_sold_to_org_id_tab(i),null,sold_to_org_id,hhst_sold_to_org_id_tab(i)),
987: invoice_to_org_id = decode(hhst_invoice_to_org_id_tab(i),null,invoice_to_org_id,hhst_invoice_to_org_id_tab(i)),
988: ship_to_org_id = decode(hhst_ship_to_org_id_tab(i),null,ship_to_org_id,hhst_ship_to_org_id_tab(i)),
989: sold_to_site_use_id = decode(hhst_sold_to_site_use_id_tab(i),null,sold_to_site_use_id,hhst_sold_to_site_use_id_tab(i)),

Line 1049: from oe_order_header_history

1045: END OE_MERGE_HEADER_HISTORY; -- 3196900
1046:
1047: /* CURSOR c1 is
1048: select HEADER_ID
1049: from oe_order_header_history
1050: where ship_to_org_id in
1051: (select m.duplicate_site_id
1052: from ra_customer_merges m
1053: where m.process_flag = 'N'

Line 1061: from oe_order_header_history

1057:
1058:
1059: CURSOR c2 is
1060: select HEADER_ID
1061: from oe_order_header_history
1062: where invoice_to_org_id in
1063: (select m.duplicate_site_id
1064: from ra_customer_merges m
1065: where m.process_flag = 'N'

Line 1073: from oe_order_header_history

1069:
1070:
1071: CURSOR c3 is
1072: select HEADER_ID
1073: from oe_order_header_history
1074: where deliver_to_org_id in
1075: (select m.duplicate_site_id
1076: from ra_customer_merges m
1077: where m.process_flag = 'N'

Line 1085: from oe_order_header_history

1081:
1082:
1083: CURSOR c4 is
1084: select HEADER_ID
1085: from oe_order_header_history
1086: where sold_to_org_id in
1087: (select m.duplicate_id
1088: from ra_customer_merges m
1089: where m.process_flag = 'N'

Line 1096: from oe_order_header_history

1092: for update nowait;
1093:
1094: CURSOR c5 is
1095: select HEADER_ID
1096: from oe_order_header_history
1097: where sold_to_site_use_id in
1098: (select m.duplicate_id
1099: from ra_customer_merges m
1100: where m.process_flag = 'N'

Line 1107: from oe_order_header_history

1103: for update nowait;
1104:
1105: CURSOR c6 is
1106: select HEADER_ID
1107: from oe_order_header_history
1108: where end_customer_site_use_id in
1109: (select m.duplicate_id
1110: from ra_customer_merges m
1111: where m.process_flag = 'N'

Line 1118: from oe_order_header_history

1114: for update nowait;
1115:
1116: CURSOR c7 is
1117: select HEADER_ID
1118: from oe_order_header_history
1119: where end_customer_id in
1120: (select m.duplicate_id
1121: from ra_customer_merges m
1122: where m.process_flag = 'N'

Line 1135: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );

1131:
1132: IF( process_mode = 'LOCK' ) THEN
1133:
1134: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1135: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1136:
1137: open c1;
1138: close c1;
1139:

Line 1163: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );

1159:
1160:
1161: -- site level update
1162: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1163: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1164:
1165: UPDATE oe_order_header_history a
1166: set ship_to_org_id = (select distinct m.customer_site_id
1167: from ra_customer_merges m

Line 1165: UPDATE oe_order_header_history a

1161: -- site level update
1162: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1163: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1164:
1165: UPDATE oe_order_header_history a
1166: set ship_to_org_id = (select distinct m.customer_site_id
1167: from ra_customer_merges m
1168: where a.ship_to_org_id = m.duplicate_site_id
1169: and m.request_id = req_id

Line 1190: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );

1186: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1187:
1188:
1189: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1190: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1191:
1192: UPDATE oe_order_header_history a
1193: set invoice_to_org_id = (select distinct m.customer_site_id
1194: from ra_customer_merges m

Line 1192: UPDATE oe_order_header_history a

1188:
1189: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1190: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1191:
1192: UPDATE oe_order_header_history a
1193: set invoice_to_org_id = (select distinct m.customer_site_id
1194: from ra_customer_merges m
1195: where a.invoice_to_org_id = m.duplicate_site_id
1196: and m.request_id = req_id

Line 1216: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );

1212: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1213: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1214:
1215: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1216: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1217:
1218: UPDATE oe_order_header_history a
1219: set deliver_to_org_id = (select distinct m.customer_site_id
1220: from ra_customer_merges m

Line 1218: UPDATE oe_order_header_history a

1214:
1215: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1216: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1217:
1218: UPDATE oe_order_header_history a
1219: set deliver_to_org_id = (select distinct m.customer_site_id
1220: from ra_customer_merges m
1221: where a.deliver_to_org_id = m.duplicate_site_id
1222: and m.request_id = req_id

Line 1242: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );

1238: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1239: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1240:
1241: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1242: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1243:
1244:
1245: -- customer level update --
1246:

Line 1248: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );

1244:
1245: -- customer level update --
1246:
1247: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1248: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
1249:
1250: UPDATE oe_order_header_history a
1251: set sold_to_org_id = (select distinct m.customer_id
1252: from ra_customer_merges m

Line 1250: UPDATE oe_order_header_history a

1246:
1247: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1248: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
1249:
1250: UPDATE oe_order_header_history a
1251: set sold_to_org_id = (select distinct m.customer_id
1252: from ra_customer_merges m
1253: where a.sold_to_org_id = m.duplicate_id
1254: and m.process_flag = 'N'

Line 1276: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );

1272: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1273: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1274:
1275: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1276: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1277:
1278: UPDATE oe_order_header_history a
1279: set sold_to_site_use_id = (select distinct m.customer_id
1280: from ra_customer_merges m

Line 1278: UPDATE oe_order_header_history a

1274:
1275: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1276: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1277:
1278: UPDATE oe_order_header_history a
1279: set sold_to_site_use_id = (select distinct m.customer_id
1280: from ra_customer_merges m
1281: where a.sold_to_site_use_id = m.duplicate_id
1282: and m.process_flag = 'N'

Line 1304: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );

1300: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1301: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1302:
1303: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1304: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1305:
1306: UPDATE oe_order_header_history a
1307: set end_customer_site_use_id = (select distinct m.customer_id
1308: from ra_customer_merges m

Line 1306: UPDATE oe_order_header_history a

1302:
1303: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1304: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1305:
1306: UPDATE oe_order_header_history a
1307: set end_customer_site_use_id = (select distinct m.customer_id
1308: from ra_customer_merges m
1309: where a.end_customer_site_use_id = m.duplicate_id
1310: and m.process_flag = 'N'

Line 1334: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );

1330:
1331: -- customer level update --
1332:
1333: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1334: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
1335:
1336: UPDATE oe_order_header_history a
1337: set end_customer_id = (select distinct m.customer_id
1338: from ra_customer_merges m

Line 1336: UPDATE oe_order_header_history a

1332:
1333: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1334: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
1335:
1336: UPDATE oe_order_header_history a
1337: set end_customer_id = (select distinct m.customer_id
1338: from ra_customer_merges m
1339: where a.end_customer_id = m.duplicate_id
1340: and m.process_flag = 'N'