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.

VIEW: APPS.OKL_PRODUCT_OPTIONS_UV

Source

View Text - Preformatted


SELECT PON.ID ID ,PON.OPTIONAL_YN OPTIONAL_YN ,PON.PDT_ID PDT_ID ,PDT.NAME PDT_NAME ,PON.OPT_ID OPT_ID ,OPT.NAME OPT_NAME ,OPT.DESCRIPTION OPT_DESCRIPTION ,PON.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,PON.FROM_DATE FROM_DATE ,PON.TO_DATE TO_DATE FROM OKL_PDT_OPTS PON,OKL_PRODUCTS PDT,OKL_OPTIONS OPT WHERE PON.PDT_ID = PDT.ID AND PON.OPT_ID = OPT.ID

View Text - HTML Formatted

SELECT PON.ID ID
, PON.OPTIONAL_YN OPTIONAL_YN
, PON.PDT_ID PDT_ID
, PDT.NAME PDT_NAME
, PON.OPT_ID OPT_ID
, OPT.NAME OPT_NAME
, OPT.DESCRIPTION OPT_DESCRIPTION
, PON.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PON.FROM_DATE FROM_DATE
, PON.TO_DATE TO_DATE
FROM OKL_PDT_OPTS PON
, OKL_PRODUCTS PDT
, OKL_OPTIONS OPT
WHERE PON.PDT_ID = PDT.ID
AND PON.OPT_ID = OPT.ID