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 485: OE_ORDER_HEADER_HISTORY HIST,

481: RA_CUSTOMER_MERGES M4,
482: RA_CUSTOMER_MERGES M5,
483: RA_CUSTOMER_MERGES M6,
484: RA_CUSTOMER_MERGES M7,
485: OE_ORDER_HEADER_HISTORY HIST,
486: -- Changed by Srini for MOAC
487: -- This MOAC change has been reverted.
488: -- For more information please
489: -- see the bug #5050382

Line 557: OE_ORDER_HEADER_HISTORY HIST,

553: RA_CUSTOMER_MERGES M4,
554: RA_CUSTOMER_MERGES M5,
555: RA_CUSTOMER_MERGES M6,
556: RA_CUSTOMER_MERGES M7,
557: OE_ORDER_HEADER_HISTORY HIST,
558: --Changed for MOAC
559: OE_ORDER_HEADERS_ALL H
560: WHERE
561: ( hist.sold_to_org_id = m1.duplicate_id(+)

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

616:
617: IF (process_mode = 'LOCK') THEN
618:
619: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
620: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
621:
622: open merge_headers_history;
623: close merge_headers_history;
624:

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

689: end if;
690:
691:
692: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
693: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
694:
695: IF hhst_header_id_tab.COUNT <> 0 THEN
696: FORALL i in hhst_header_id_tab.FIRST..hhst_header_id_tab.LAST
697: UPDATE OE_ORDER_HEADER_HISTORY HHIST

Line 697: UPDATE OE_ORDER_HEADER_HISTORY HHIST

693: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
694:
695: IF hhst_header_id_tab.COUNT <> 0 THEN
696: FORALL i in hhst_header_id_tab.FIRST..hhst_header_id_tab.LAST
697: UPDATE OE_ORDER_HEADER_HISTORY HHIST
698: 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)),
699: invoice_to_org_id = decode(hhst_invoice_to_org_id_tab(i),null,invoice_to_org_id,hhst_invoice_to_org_id_tab(i)),
700: ship_to_org_id = decode(hhst_ship_to_org_id_tab(i),null,ship_to_org_id,hhst_ship_to_org_id_tab(i)),
701: 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 751: from oe_order_header_history

747: END OE_MERGE_HEADER_HISTORY; -- 3196900
748:
749: /* CURSOR c1 is
750: select HEADER_ID
751: from oe_order_header_history
752: where ship_to_org_id in
753: (select m.duplicate_site_id
754: from ra_customer_merges m
755: where m.process_flag = 'N'

Line 763: from oe_order_header_history

759:
760:
761: CURSOR c2 is
762: select HEADER_ID
763: from oe_order_header_history
764: where invoice_to_org_id in
765: (select m.duplicate_site_id
766: from ra_customer_merges m
767: where m.process_flag = 'N'

Line 775: from oe_order_header_history

771:
772:
773: CURSOR c3 is
774: select HEADER_ID
775: from oe_order_header_history
776: where deliver_to_org_id in
777: (select m.duplicate_site_id
778: from ra_customer_merges m
779: where m.process_flag = 'N'

Line 787: from oe_order_header_history

783:
784:
785: CURSOR c4 is
786: select HEADER_ID
787: from oe_order_header_history
788: where sold_to_org_id in
789: (select m.duplicate_id
790: from ra_customer_merges m
791: where m.process_flag = 'N'

Line 798: from oe_order_header_history

794: for update nowait;
795:
796: CURSOR c5 is
797: select HEADER_ID
798: from oe_order_header_history
799: where sold_to_site_use_id in
800: (select m.duplicate_id
801: from ra_customer_merges m
802: where m.process_flag = 'N'

Line 809: from oe_order_header_history

805: for update nowait;
806:
807: CURSOR c6 is
808: select HEADER_ID
809: from oe_order_header_history
810: where end_customer_site_use_id in
811: (select m.duplicate_id
812: from ra_customer_merges m
813: where m.process_flag = 'N'

Line 820: from oe_order_header_history

816: for update nowait;
817:
818: CURSOR c7 is
819: select HEADER_ID
820: from oe_order_header_history
821: where end_customer_id in
822: (select m.duplicate_id
823: from ra_customer_merges m
824: where m.process_flag = 'N'

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

833:
834: IF( process_mode = 'LOCK' ) THEN
835:
836: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
837: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
838:
839: open c1;
840: close c1;
841:

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

861:
862:
863: -- site level update
864: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
865: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
866:
867: UPDATE oe_order_header_history a
868: set ship_to_org_id = (select distinct m.customer_site_id
869: from ra_customer_merges m

Line 867: UPDATE oe_order_header_history a

863: -- site level update
864: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
865: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
866:
867: UPDATE oe_order_header_history a
868: set ship_to_org_id = (select distinct m.customer_site_id
869: from ra_customer_merges m
870: where a.ship_to_org_id = m.duplicate_site_id
871: and m.request_id = req_id

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

888: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
889:
890:
891: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
892: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
893:
894: UPDATE oe_order_header_history a
895: set invoice_to_org_id = (select distinct m.customer_site_id
896: from ra_customer_merges m

Line 894: UPDATE oe_order_header_history a

890:
891: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
892: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
893:
894: UPDATE oe_order_header_history a
895: set invoice_to_org_id = (select distinct m.customer_site_id
896: from ra_customer_merges m
897: where a.invoice_to_org_id = m.duplicate_site_id
898: and m.request_id = req_id

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

914: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
915: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
916:
917: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
918: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
919:
920: UPDATE oe_order_header_history a
921: set deliver_to_org_id = (select distinct m.customer_site_id
922: from ra_customer_merges m

Line 920: UPDATE oe_order_header_history a

916:
917: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
918: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
919:
920: UPDATE oe_order_header_history a
921: set deliver_to_org_id = (select distinct m.customer_site_id
922: from ra_customer_merges m
923: where a.deliver_to_org_id = m.duplicate_site_id
924: and m.request_id = req_id

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

940: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
941: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
942:
943: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
944: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
945:
946:
947: -- customer level update --
948:

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

946:
947: -- customer level update --
948:
949: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
950: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
951:
952: UPDATE oe_order_header_history a
953: set sold_to_org_id = (select distinct m.customer_id
954: from ra_customer_merges m

Line 952: UPDATE oe_order_header_history a

948:
949: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
950: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
951:
952: UPDATE oe_order_header_history a
953: set sold_to_org_id = (select distinct m.customer_id
954: from ra_customer_merges m
955: where a.sold_to_org_id = m.duplicate_id
956: and m.process_flag = 'N'

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

974: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
975: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
976:
977: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
978: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
979:
980: UPDATE oe_order_header_history a
981: set sold_to_site_use_id = (select distinct m.customer_id
982: from ra_customer_merges m

Line 980: UPDATE oe_order_header_history a

976:
977: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
978: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
979:
980: UPDATE oe_order_header_history a
981: set sold_to_site_use_id = (select distinct m.customer_id
982: from ra_customer_merges m
983: where a.sold_to_site_use_id = m.duplicate_id
984: and m.process_flag = 'N'

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

1002: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1003: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1004:
1005: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1006: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1007:
1008: UPDATE oe_order_header_history a
1009: set end_customer_site_use_id = (select distinct m.customer_id
1010: from ra_customer_merges m

Line 1008: UPDATE oe_order_header_history a

1004:
1005: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1006: arp_message.set_token( 'TABLE_NAME', 'OE_ORDER_HEADER_HISTORY', FALSE );
1007:
1008: UPDATE oe_order_header_history a
1009: set end_customer_site_use_id = (select distinct m.customer_id
1010: from ra_customer_merges m
1011: where a.end_customer_site_use_id = m.duplicate_id
1012: and m.process_flag = 'N'

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

1032:
1033: -- customer level update --
1034:
1035: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1036: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
1037:
1038: UPDATE oe_order_header_history a
1039: set end_customer_id = (select distinct m.customer_id
1040: from ra_customer_merges m

Line 1038: UPDATE oe_order_header_history a

1034:
1035: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1036: arp_message.set_token( 'TABLE_NAME', 'oe_order_header_history', FALSE );
1037:
1038: UPDATE oe_order_header_history a
1039: set end_customer_id = (select distinct m.customer_id
1040: from ra_customer_merges m
1041: where a.end_customer_id = m.duplicate_id
1042: and m.process_flag = 'N'