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_LINES_ALL

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

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
923: )
924:
925: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
926: )

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

921:
922: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
923: )
924:
925: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
926: )
927:
928: or exists (select 'Y' from HZ_PARTY_SITES
929: xx where xx.PARTY_ID = temp.party_id

Line 932: (select 'Y' from ASO_QUOTE_LINES_ALL

928: or exists (select 'Y' from HZ_PARTY_SITES
929: xx where xx.PARTY_ID = temp.party_id
930: and (nvl(STATUS, 'A') in ('A','I'))
931: and exists
932: (select 'Y' from ASO_QUOTE_LINES_ALL
933: yy where yy.END_CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
934: ));
935: else
936: delete from hz_purge_gt temp where

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

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
968: )
969:
970: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
971: )

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

966:
967: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_PARTY_ID = temp.party_id
968: )
969:
970: or exists (select 'Y' from ASO_QUOTE_LINES_ALL xx where xx.END_CUSTOMER_CUST_PARTY_ID = temp.party_id
971: )
972:
973: or exists (select 'Y' from HZ_PARTY_SITES
974: xx where xx.PARTY_ID = temp.party_id

Line 977: (select 'Y' from ASO_QUOTE_LINES_ALL

973: or exists (select 'Y' from HZ_PARTY_SITES
974: xx where xx.PARTY_ID = temp.party_id
975: and (nvl(STATUS, 'A') in ('A','I'))
976: and exists
977: (select 'Y' from ASO_QUOTE_LINES_ALL
978: yy where yy.END_CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
979: ));
980: end if;
981:

Line 3764: --ASO_QUOTE_LINES_ALL;INVOICE_TO_PARTY_ID

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;
3766: if(regid_proc = true) then
3767: 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
3768:

Line 3769: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3765: appid:=697;
3766: if(regid_proc = true) then
3767: 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
3768:
3769: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3770: );
3771: else
3772: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3773: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx

Line 3773: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3769: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3770: );
3771: else
3772: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3773: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3774: );
3775: end if;
3776: --ASO_SHIPMENTS;SHIP_TO_PARTY_ID
3777: appid:=697;

Line 3810: --ASO_QUOTE_LINES_ALL;INVOICE_TO_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
3811: appid:=697;
3812: if(regid_proc = true) then
3813: 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
3814:

Line 3819: in (select /+ parallel(yy)/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

3815: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3816: xx
3817: where (nvl(STATUS, 'A') in ('A','I'))
3818: and xx.PARTY_SITE_ID
3819: in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
3820: yy
3821: ));
3822: else
3823: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3828: in (select /+ parallel(yy)/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL

3824: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3825: xx
3826: where (nvl(STATUS, 'A') in ('A','I'))
3827: and xx.PARTY_SITE_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

Line 3866: --ASO_QUOTE_LINES_ALL;INVOICE_TO_CUST_PARTY_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
3867: appid:=697;
3868: if(regid_proc = true) then
3869: 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
3870:

Line 3871: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3867: appid:=697;
3868: if(regid_proc = true) then
3869: 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
3870:
3871: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3872: );
3873: else
3874: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3875: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

Line 3875: temp.party_id in (select /+ parallel(xx)/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx

3871: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3872: );
3873: else
3874: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3875: temp.party_id in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx
3876: );
3877: end if;
3878: --ASO_SHIPMENTS;SHIP_TO_CUST_PARTY_ID
3879: appid:=697;