DBA Data[Home] [Help]

APPS.PER_PERSON_INFORMATION dependencies on FND_APPLICATION_ALL_VIEW

Line 91: FROM fnd_application_all_view v

87: SELECT v.application_name||'('||v.application_short_name||')' application
88: ,v.application_id id
89: ,l.meaning installstatus
90: ,nvl(substr(i.patch_level,1,12),' ') patchlevel
91: FROM fnd_application_all_view v
92: ,fnd_product_installations i
93: ,fnd_lookups l
94: WHERE v.application_id = i.application_id
95: AND v.application_id in (0, 800, 801, 802, 803, 805, 808, 809, 810, 8301, 8302, 178)