Subversion Repositories DevTools

Rev

Rev 5945 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5945 Rev 5947
Line 3... Line 3...
3 
--  Within an SDK specified by :SDK_ID
 3 
--  Within an SDK specified by :SDK_ID
4 
--  Match control via :MATCH
 4 
--  Match control via :MATCH
5 
--    :MATCH 0  - Match any  package name
 5 
--    :MATCH 0  - Match any  package name
6 
--    :MATCH 1  - Match Package name and Project Suffix
 6 
--    :MATCH 1  - Match Package name and Project Suffix
7 
--    :MATCH 2  - Match exactly the package. Name, Version and Suffix
 7 
--    :MATCH 2  - Match exactly the package. Name, Version and Suffix
- 
 
 8 
 with
- 
 
 9 
  aa AS ( select NVL(v_ext,'LINK') as ext from package_versions where pv_id = :PV_ID),
- 
 
 10 
  bb AS (select pkg_id from package_versions where pv_id = :PV_ID)
8 
SELECT DISTINCT SDK_NAME,
11 
SELECT DISTINCT SDK_NAME,
9 
        st.sdk_state,
12 
        st.sdk_state,
10 
        st.SDK_ID,
13 
        st.SDK_ID,
11 
        st.SDKTAG_NAME,
14 
        st.SDKTAG_NAME,
12 
        st.SDKTAG_ID,
15 
        st.SDKTAG_ID,
Line 21... Line 24...
21 
FROM SDK_CONTENT sc,
 24 
FROM SDK_CONTENT sc,
22 
  SDK_TAGS st,
 25 
  SDK_TAGS st,
23 
  SDK_NAMES sn,
 26 
  SDK_NAMES sn,
24 
  PACKAGE_VERSIONS pv,
 27 
  PACKAGE_VERSIONS pv,
25 
  PACKAGES pkg,
 28 
  PACKAGES pkg,
26 
  USERS usr
 29 
  USERS usr,
- 
 
 30 
  aa,bb
27 
WHERE sc.SDKTAG_ID = st.SDKTAG_ID
31 
WHERE sc.SDKTAG_ID = st.SDKTAG_ID
28 
  AND (sc.PV_ID  = :PV_ID OR :MATCH != 2)
 32 
  AND (sc.PV_ID  = :PV_ID OR :MATCH != 2)
29 
  AND (NVL(pv.v_ext,'LINK') in ( select NVL(v_ext,'LINK') from package_versions where pv_id = :PV_ID ) OR :MATCH = 2 OR :MATCH = 0)
 33 
  AND (NVL(pv.v_ext,'LINK') in (  aa.ext ) OR :MATCH = 2 OR :MATCH = 0)
30 
  AND (pv.PKG_ID in ( select pkg_id from package_versions where pv_id = :PV_ID) OR :MATCH = 2)
 34 
  AND (pv.PKG_ID in ( bb.pkg_id ) OR :MATCH = 2)
31 
  AND st.SDK_ID = sn.SDK_ID
 35 
  AND st.SDK_ID = sn.SDK_ID
32 
  AND sc.PV_ID = pv.PV_ID
 36 
  AND sc.PV_ID = pv.PV_ID
33 
  AND st.SDK_ID = :SDK_ID
 37 
  AND st.SDK_ID = :SDK_ID
34 
  AND pv.pkg_id = pkg.pkg_id
 38 
  AND pv.pkg_id = pkg.pkg_id
35 
  AND pv.MODIFIER_ID = usr.USER_ID(+)
 39 
  AND pv.MODIFIER_ID = usr.USER_ID(+)