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.AD_PA_CRITERIA_UTIL dependencies on AD_PM_PRODUCT_INFO

Line 62: ad_pm_product_info pi, ad_pm_prod_family_map pfm

58: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
59: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
60: select distinct pfm.product_family_abbreviation,'Recommended Patches','Y','N','Y',sysdate,1,sysdate,1
61: from fnd_product_installations fpi, fnd_application a,
62: ad_pm_product_info pi, ad_pm_prod_family_map pfm
63: where fpi.status in ('S', 'I')
64: and fpi.application_id = a.application_id
65: and a.application_short_name= pi.application_short_name
66: and pi.PSEUDO_PRODUCT_FLAG='N'

Line 75: from ad_pm_product_info pi

71: insert into ad_pa_criteria_prod_fams
72: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
73: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
74: select distinct pi.product_abbreviation,'Recommended Patches', 'Y', 'N', 'N',sysdate, 1, sysdate, 1
75: from ad_pm_product_info pi
76: where pi.pseudo_product_flag='Y'
77: and pi.product_family_flag='Y'
78: and not exists
79: (select 'X' from ad_pa_criteria_prod_fams adf

Line 87: select pi.PRODUCT_FAMILY_ABBREVIATION adi_prod_abbr, pfm.product_family_abbreviation adp_prod_abbr from ad_pm_product_info pi, ad_pa_criteria_prod_fams pfm

83:
84: BEGIN
85: DECLARE
86: cursor prod_family is
87: select pi.PRODUCT_FAMILY_ABBREVIATION adi_prod_abbr, pfm.product_family_abbreviation adp_prod_abbr from ad_pm_product_info pi, ad_pa_criteria_prod_fams pfm
88: where pfm.PRODUCT_FAMILY_ABBREVIATION = pi.PRODUCT_FAMILY_ABBREVIATION
89: and pfm.ADVISOR_CRITERIA_ID ='Recommended Patches' for update of pfm.product_family_abbreviation;
90: prod_abb prod_family%ROWTYPE;
91: begin

Line 172: ad_pm_product_info pi, ad_pm_prod_family_map pfm

168: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
169: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
170: select distinct pfm.product_family_abbreviation,'New Codelevels','N','Y','Y',sysdate,1,sysdate,1
171: from fnd_product_installations fpi, fnd_application a,
172: ad_pm_product_info pi, ad_pm_prod_family_map pfm
173: where fpi.status in ('S', 'I')
174: and fpi.application_id = a.application_id
175: and a.application_short_name= pi.application_short_name
176: and pi.PSEUDO_PRODUCT_FLAG='N'

Line 183: from ad_pm_product_info pi

179: insert into ad_pa_criteria_prod_fams
180: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
181: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
182: select distinct pi.product_abbreviation,'New Codelevels', 'N', 'Y', 'N',sysdate, 1, sysdate, 1
183: from ad_pm_product_info pi
184: where pi.pseudo_product_flag='Y'
185: and pi.product_family_flag='Y'
186: and not exists
187: (select 'X' from ad_pa_criteria_prod_fams adf

Line 195: select adi.PRODUCT_FAMILY_ABBREVIATION adi_prod_abbr, adp.product_family_abbreviation adp_prod_abbr from ad_pm_product_info adi, ad_pa_criteria_prod_fams adp

191:
192: BEGIN
193: DECLARE
194: cursor prod_family is
195: select adi.PRODUCT_FAMILY_ABBREVIATION adi_prod_abbr, adp.product_family_abbreviation adp_prod_abbr from ad_pm_product_info adi, ad_pa_criteria_prod_fams adp
196: where adp.PRODUCT_FAMILY_ABBREVIATION = adi.PRODUCT_FAMILY_ABBREVIATION
197: and adp.ADVISOR_CRITERIA_ID ='New Codelevels' for update of adp.product_family_abbreviation;
198: prod_abb prod_family%ROWTYPE;
199: begin

Line 279: ad_pm_product_info pi, ad_pm_prod_family_map pfm

275: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
276: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
277: select distinct pfm.product_family_abbreviation,'Recommended Patches and New Codelevels','Y','Y','Y',sysdate,1,sysdate,1
278: from fnd_product_installations fpi, fnd_application a,
279: ad_pm_product_info pi, ad_pm_prod_family_map pfm
280: where fpi.status in ('S', 'I')
281: and fpi.application_id = a.application_id
282: and a.application_short_name= pi.application_short_name
283: and pi.PSEUDO_PRODUCT_FLAG='N'

Line 290: from ad_pm_product_info pi

286: insert into ad_pa_criteria_prod_fams
287: (PRODUCT_FAMILY_ABBREVIATION,ADVISOR_CRITERIA_ID,RECOMMENDED_PATCH_FLAG,NEW_CODE_LEVEL_FLAG,LICENSED_FLAG,
288: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
289: select distinct pi.product_abbreviation,'Recommended Patches and New Codelevels', 'Y', 'Y', 'N',sysdate, 1, sysdate, 1
290: from ad_pm_product_info pi
291: where pi.pseudo_product_flag='Y'
292: and pi.product_family_flag='Y'
293: and not exists
294: (select 'X' from ad_pa_criteria_prod_fams adf

Line 302: select adi.PRODUCT_FAMILY_ABBREVIATION adi_prod_abbr, adp.product_family_abbreviation adp_prod_abbr from ad_pm_product_info adi, ad_pa_criteria_prod_fams adp

298:
299: BEGIN
300: DECLARE
301: cursor prod_family is
302: select adi.PRODUCT_FAMILY_ABBREVIATION adi_prod_abbr, adp.product_family_abbreviation adp_prod_abbr from ad_pm_product_info adi, ad_pa_criteria_prod_fams adp
303: where adp.PRODUCT_FAMILY_ABBREVIATION = adi.PRODUCT_FAMILY_ABBREVIATION
304: and adp.ADVISOR_CRITERIA_ID ='Recommended Patches and New Codelevels' for update of adp.product_family_abbreviation;
305: prod_abb prod_family%ROWTYPE;
306: begin