DBA Data[Home] [Help]

APPS.FND_IMP_PKG dependencies on AD_PM_PATCHES

Line 15: where umsts.bug_number = (select bug_number from ad_pm_patches where patch_id = patch_id__) AND --ang

11: from ad_snapshots adts where adts.snapshot_id = snapshot_id__
12: UNION ALL
13: select max(greatest(umsts.last_update_date, umsts.last_definition_date)) ts
14: from fnd_ums_bugfixes umsts
15: where umsts.bug_number = (select bug_number from ad_pm_patches where patch_id = patch_id__) AND --ang
16: umsts.baseline = (select baseline from ad_pm_patches where patch_id = patch_id__) --ang
17: ) z;
18:
19: return answ__;

Line 16: umsts.baseline = (select baseline from ad_pm_patches where patch_id = patch_id__) --ang

12: UNION ALL
13: select max(greatest(umsts.last_update_date, umsts.last_definition_date)) ts
14: from fnd_ums_bugfixes umsts
15: where umsts.bug_number = (select bug_number from ad_pm_patches where patch_id = patch_id__) AND --ang
16: umsts.baseline = (select baseline from ad_pm_patches where patch_id = patch_id__) --ang
17: ) z;
18:
19: return answ__;
20: END lastupdate;