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 2716: (select 'Y' from CS_ESTIMATE_DETAILS

2712: or exists (select 'Y' from HZ_PARTY_SITES
2713: xx where xx.PARTY_ID = temp.party_id
2714: and (nvl(STATUS, 'A') in ('A','I'))
2715: and exists
2716: (select 'Y' from CS_ESTIMATE_DETAILS
2717: yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
2718: ))
2719:
2720: or exists (select 'Y' from HZ_PARTY_SITES

Line 2724: (select 'Y' from CS_ESTIMATE_DETAILS

2720: or exists (select 'Y' from HZ_PARTY_SITES
2721: xx where xx.PARTY_ID = temp.party_id
2722: and (nvl(STATUS, 'A') in ('A','I'))
2723: and exists
2724: (select 'Y' from CS_ESTIMATE_DETAILS
2725: yy where yy.SHIP_TO_ORG_ID=xx.PARTY_SITE_ID
2726: ));
2727: else
2728: delete from hz_purge_gt temp where

Line 2741: (select 'Y' from CS_ESTIMATE_DETAILS

2737: or exists (select 'Y' from HZ_PARTY_SITES
2738: xx where xx.PARTY_ID = temp.party_id
2739: and (nvl(STATUS, 'A') in ('A','I'))
2740: and exists
2741: (select 'Y' from CS_ESTIMATE_DETAILS
2742: yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
2743: ))
2744:
2745: or exists (select 'Y' from HZ_PARTY_SITES

Line 2749: (select 'Y' from CS_ESTIMATE_DETAILS

2745: or exists (select 'Y' from HZ_PARTY_SITES
2746: xx where xx.PARTY_ID = temp.party_id
2747: and (nvl(STATUS, 'A') in ('A','I'))
2748: and exists
2749: (select 'Y' from CS_ESTIMATE_DETAILS
2750: yy where yy.SHIP_TO_ORG_ID=xx.PARTY_SITE_ID
2751: ));
2752: end if;
2753:

Line 4866: --CS_ESTIMATE_DETAILS;BILL_TO_PARTY_ID

4862: in (select /*+ parallel(yy)*/ yy.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS
4863: yy
4864: where (qualifier_context = 'ASOPARTYINFO' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11') OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));
4865: end if;
4866: --CS_ESTIMATE_DETAILS;BILL_TO_PARTY_ID
4867: appid:=170;
4868: if(regid_proc = true) then
4869: 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
4870:

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

4867: appid:=170;
4868: if(regid_proc = true) then
4869: 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
4870:
4871: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4872: );
4873: else
4874: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4875: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

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

4871: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4872: );
4873: else
4874: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4875: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4876: );
4877: end if;
4878: --CS_ESTIMATE_DETAILS;SHIP_TO_PARTY_ID
4879: appid:=170;

Line 4878: --CS_ESTIMATE_DETAILS;SHIP_TO_PARTY_ID

4874: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4875: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4876: );
4877: end if;
4878: --CS_ESTIMATE_DETAILS;SHIP_TO_PARTY_ID
4879: appid:=170;
4880: if(regid_proc = true) then
4881: 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
4882:

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

4879: appid:=170;
4880: if(regid_proc = true) then
4881: 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
4882:
4883: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4884: );
4885: else
4886: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4887: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx

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

4883: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4884: );
4885: else
4886: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4887: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx
4888: );
4889: end if;
4890: --CS_INCIDENTS_ALL_B;SITE_ID
4891: appid:=170;