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.HZ_PURGE_GEN dependencies on ASO_QUOTE_HEADERS_ALL

Line 894: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id

890: if(regid_proc = true) then
891: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where
892:
893:
894: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id
895: )
896:
897: or exists (select 'Y' from HZ_PARTY_SITES
898: xx where xx.PARTY_ID = temp.party_id

Line 905: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id

901: (select 'Y' from ASO_SHIPMENTS
902: yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
903: ))
904:
905: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id
906: )
907:
908: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
909: )

Line 908: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id

904:
905: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id
906: )
907:
908: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
909: )
910:
911: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
912: )

Line 911: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id

907:
908: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
909: )
910:
911: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
912: )
913:
914: or exists (select 'Y' from HZ_PARTY_SITES
915: xx where xx.PARTY_ID = temp.party_id

Line 918: (select 'Y' from ASO_QUOTE_HEADERS_ALL

914: or exists (select 'Y' from HZ_PARTY_SITES
915: xx where xx.PARTY_ID = temp.party_id
916: and (nvl(STATUS, 'A') in ('A','I'))
917: and exists
918: (select 'Y' from ASO_QUOTE_HEADERS_ALL
919: yy where yy.END_CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
920: ))
921:
922: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id

Line 939: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id

935: else
936: delete from hz_purge_gt temp where
937:
938:
939: exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID = temp.party_id
940: )
941:
942: or exists (select 'Y' from HZ_PARTY_SITES
943: xx where xx.PARTY_ID = temp.party_id

Line 950: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id

946: (select 'Y' from ASO_SHIPMENTS
947: yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
948: ))
949:
950: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id
951: )
952:
953: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
954: )

Line 953: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id

949:
950: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID = temp.party_id
951: )
952:
953: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
954: )
955:
956: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
957: )

Line 956: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id

952:
953: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
954: )
955:
956: or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
957: )
958:
959: or exists (select 'Y' from HZ_PARTY_SITES
960: xx where xx.PARTY_ID = temp.party_id

Line 963: (select 'Y' from ASO_QUOTE_HEADERS_ALL

959: or exists (select 'Y' from HZ_PARTY_SITES
960: xx where xx.PARTY_ID = temp.party_id
961: and (nvl(STATUS, 'A') in ('A','I'))
962: and exists
963: (select 'Y' from ASO_QUOTE_HEADERS_ALL
964: yy where yy.END_CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
965: ))
966:
967: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id

Line 3752: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_ID

3748: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CSI_T_TXN_SYSTEMS
3749: yy
3750: ));
3751: end if;
3752: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_ID
3753: appid:=697;
3754: if(regid_proc = true) then
3755: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3756:

Line 3757: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

3753: appid:=697;
3754: if(regid_proc = true) then
3755: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3756:
3757: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3758: );
3759: else
3760: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3761: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

Line 3761: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

3757: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3758: );
3759: else
3760: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3761: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3762: );
3763: end if;
3764: --ASO_QUOTE_LINES_ALL;INVOICE_TO_PARTY_ID
3765: appid:=697;

Line 3788: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_SITE_ID

3784: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3785: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx
3786: );
3787: end if;
3788: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_PARTY_SITE_ID
3789: appid:=697;
3790: if(regid_proc = true) then
3791: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3792:

Line 3797: in (select /+ parallel(yy)/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3793: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3794: xx
3795: where (nvl(STATUS, 'A') in ('A','I'))
3796: and xx.PARTY_SITE_ID
3797: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3798: yy
3799: ));
3800: else
3801: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3806: in (select /+ parallel(yy)/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3802: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3803: xx
3804: where (nvl(STATUS, 'A') in ('A','I'))
3805: and xx.PARTY_SITE_ID
3806: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3807: yy
3808: ));
3809: end if;
3810: --ASO_QUOTE_LINES_ALL;INVOICE_TO_PARTY_SITE_ID

Line 3832: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_CUST_PARTY_ID

3828: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
3829: yy
3830: ));
3831: end if;
3832: --ASO_QUOTE_HEADERS_ALL;INVOICE_TO_CUST_PARTY_ID
3833: appid:=697;
3834: if(regid_proc = true) then
3835: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3836:

Line 3837: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

3833: appid:=697;
3834: if(regid_proc = true) then
3835: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3836:
3837: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3838: );
3839: else
3840: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3841: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

Line 3841: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx

3837: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3838: );
3839: else
3840: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3841: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3842: );
3843: end if;
3844: --ASO_QUOTE_HEADERS_ALL;SOLD_TO_PARTY_SITE_ID
3845: appid:=697;

Line 3844: --ASO_QUOTE_HEADERS_ALL;SOLD_TO_PARTY_SITE_ID

3840: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3841: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx
3842: );
3843: end if;
3844: --ASO_QUOTE_HEADERS_ALL;SOLD_TO_PARTY_SITE_ID
3845: appid:=697;
3846: if(regid_proc = true) then
3847: insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and
3848:

Line 3853: in (select /+ parallel(yy)/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3849: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3850: xx
3851: where (nvl(STATUS, 'A') in ('A','I'))
3852: and xx.PARTY_SITE_ID
3853: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3854: yy
3855: ));
3856: else
3857: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3862: in (select /+ parallel(yy)/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL

3858: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3859: xx
3860: where (nvl(STATUS, 'A') in ('A','I'))
3861: and xx.PARTY_SITE_ID
3862: in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
3863: yy
3864: ));
3865: end if;
3866: --ASO_QUOTE_LINES_ALL;INVOICE_TO_CUST_PARTY_ID