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 CS_ESTIMATE_DETAILS

Line 2809: (select 'Y' from CS_ESTIMATE_DETAILS

2805: or exists (select 'Y' from HZ_PARTY_SITES
2806: xx where xx.PARTY_ID = temp.party_id
2807: and (nvl(STATUS, 'A') in ('A','I'))
2808: and exists
2809: (select 'Y' from CS_ESTIMATE_DETAILS
2810: yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
2811: ))
2812:
2813: or exists (select 'Y' from HZ_PARTY_SITES

Line 2817: (select 'Y' from CS_ESTIMATE_DETAILS

2813: or exists (select 'Y' from HZ_PARTY_SITES
2814: xx where xx.PARTY_ID = temp.party_id
2815: and (nvl(STATUS, 'A') in ('A','I'))
2816: and exists
2817: (select 'Y' from CS_ESTIMATE_DETAILS
2818: yy where yy.SHIP_TO_ORG_ID=xx.PARTY_SITE_ID
2819: ));
2820: else
2821: delete from hz_purge_gt temp where

Line 2834: (select 'Y' from CS_ESTIMATE_DETAILS

2830: or exists (select 'Y' from HZ_PARTY_SITES
2831: xx where xx.PARTY_ID = temp.party_id
2832: and (nvl(STATUS, 'A') in ('A','I'))
2833: and exists
2834: (select 'Y' from CS_ESTIMATE_DETAILS
2835: yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
2836: ))
2837:
2838: or exists (select 'Y' from HZ_PARTY_SITES

Line 2842: (select 'Y' from CS_ESTIMATE_DETAILS

2838: or exists (select 'Y' from HZ_PARTY_SITES
2839: xx where xx.PARTY_ID = temp.party_id
2840: and (nvl(STATUS, 'A') in ('A','I'))
2841: and exists
2842: (select 'Y' from CS_ESTIMATE_DETAILS
2843: yy where yy.SHIP_TO_ORG_ID=xx.PARTY_SITE_ID
2844: ));
2845: end if;
2846:

Line 5086: --CS_ESTIMATE_DETAILS;BILL_TO_PARTY_ID

5082: in (select /*+ parallel(yy)*/ yy.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS
5083: yy
5084: where (qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
5085: end if;
5086: --CS_ESTIMATE_DETAILS;BILL_TO_PARTY_ID
5087: appid:=170;
5088: if(regid_proc = true) then
5089: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5090:

Line 5091: temp.party_id in (select /+ parallel(xx)/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

5087: appid:=170;
5088: if(regid_proc = true) then
5089: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5090:
5091: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5092: );
5093: else
5094: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5095: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

Line 5095: temp.party_id in (select /+ parallel(xx)/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

5091: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5092: );
5093: else
5094: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5095: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5096: );
5097: end if;
5098: --CS_ESTIMATE_DETAILS;SHIP_TO_PARTY_ID
5099: appid:=170;

Line 5098: --CS_ESTIMATE_DETAILS;SHIP_TO_PARTY_ID

5094: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5095: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5096: );
5097: end if;
5098: --CS_ESTIMATE_DETAILS;SHIP_TO_PARTY_ID
5099: appid:=170;
5100: if(regid_proc = true) then
5101: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5102:

Line 5103: temp.party_id in (select /+ parallel(xx)/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

5099: appid:=170;
5100: if(regid_proc = true) then
5101: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5102:
5103: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5104: );
5105: else
5106: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5107: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

Line 5107: temp.party_id in (select /+ parallel(xx)/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

5103: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5104: );
5105: else
5106: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5107: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
5108: );
5109: end if;
5110: --CS_INCIDENTS_ALL_B;SITE_ID
5111: appid:=170;