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 FND_PRODUCT_INSTALLATIONS

Line 18: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'

14: -- in ad_pa_advisor_criteria (create if not exists)
15: --
16: -- Then delete rows from ad_pa_criteria_prod_fams.
17: --
18: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'
19: -- create row in ad_pa_criteria_prod_fams for this
20: -- criteria set and product Family with Recommended Patches flag and licensed flag set Y and other flags N
21: --
22: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'

Line 22: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'

18: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'
19: -- create row in ad_pa_criteria_prod_fams for this
20: -- criteria set and product Family with Recommended Patches flag and licensed flag set Y and other flags N
21: --
22: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'
23: -- create row in ad_pa_criteria_prod_fams for this
24: -- criteria set and product Family with Recommended Patches flag set Y and other flags N including licensed flag
25: --
26: -- Change last_update_date for this criteria set in ad_pa_advisor_criteria

Line 61: from fnd_product_installations fpi, fnd_application a,

57: insert into ad_pa_criteria_prod_fams
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

Line 131: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'

127: -- in ad_pa_advisor_criteria (create if not exists)
128: --
129: -- Then delete rows from ad_pa_criteria_prod_fams.
130: --
131: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'
132: -- create row in ad_pa_criteria_prod_fams for this
133: -- criteria set and product Family with New Code Levels flag and licensed flag set Y and other flags N
134: --
135: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'

Line 135: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'

131: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'
132: -- create row in ad_pa_criteria_prod_fams for this
133: -- criteria set and product Family with New Code Levels flag and licensed flag set Y and other flags N
134: --
135: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'
136: -- create row in ad_pa_criteria_prod_fams for this
137: -- criteria set and product Family with New Code Levels flag set Y and other flags N including licensed flag
138: --
139: -- Change last_update_date for this criteria set in ad_pa_advisor_criteria

Line 171: from fnd_product_installations fpi, fnd_application a,

167: insert into ad_pa_criteria_prod_fams
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

Line 238: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'

234: -- in ad_pa_advisor_criteria (create if not exists)
235: --
236: -- Then delete rows from ad_pa_criteria_prod_fams.
237: --
238: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'
239: -- create row in ad_pa_criteria_prod_fams for this
240: -- criteria set and product Family with Recommended Patches plus New Code Levels flag and licensed flag set Y and other flags N
241: --
242: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'

Line 242: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'

238: -- For all products in FND_PRODUCT_INSTALLATIONS with status='I' and 'S'
239: -- create row in ad_pa_criteria_prod_fams for this
240: -- criteria set and product Family with Recommended Patches plus New Code Levels flag and licensed flag set Y and other flags N
241: --
242: -- For all products in FND_PRODUCT_INSTALLATIONS with status != 'I' and 'S'
243: -- create row in ad_pa_criteria_prod_fams for this
244: -- criteria set and product Family with Recommended Patches plus New Code Levels flag set Y and other flags N including licensed flag
245: --
246: -- Change last_update_date for this criteria set in ad_pa_advisor_criteria

Line 278: from fnd_product_installations fpi, fnd_application a,

274: insert into ad_pa_criteria_prod_fams
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