| 5685 |
dpurdie |
1 |
SELECT * from (
|
|
|
2 |
SELECT p.PKG_NAME, pv.PKG_VERSION, pc.pv_id,
|
|
|
3 |
'/' || REPLACE(NVL(pc.FILE_PATH,''),'\','/') ||pc.FILE_NAME as filename
|
|
|
4 |
FROM RELEASE_COMPONENTS pc, PACKAGE_VERSIONS pv, packages p
|
|
|
5 |
WHERE pc.pv_id = pv.pv_id
|
|
|
6 |
and p.pkg_id = pv.pkg_id
|
|
|
7 |
and pc.file_name is not null
|
|
|
8 |
AND UPPER(p.pkg_name) like UPPER('/*PKG_NAME*/')
|
|
|
9 |
)
|
|
|
10 |
where upper(filename) like Upper('/*FILE_NAME*/')
|
|
|
11 |
order by pkg_version, upper(filename)
|