VIEW: APPS.PSP_ENC_ELEMENTS_V

Source

View Text - Preformatted

SELECT A.ENC_ELEMENT_ID, PIV.NAME INPUT_VALUE, A.INPUT_VALUE_ID, FF.FORMULA_NAME, A.FORMULA_ID, A.BUSINESS_GROUP_ID, A.SET_OF_BOOKS_ID , A.ELEMENT_TYPE_CATEGORY, A.ELEMENT_TYPE_ID, B.ELEMENT_NAME, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_LOGIN, A.CREATED_BY, A.CREATION_DATE FROM PSP_ENC_ELEMENTS A , PAY_ELEMENT_TYPES_F B, PAY_INPUT_VALUES_F PIV, FF_FORMULAS_F FF WHERE A.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID AND PIV.INPUT_VALUE_ID (+) = A.INPUT_VALUE_ID AND FF.FORMULA_ID (+) = A.FORMULA_ID AND B.ROWID IN (SELECT MIN(ROWID) FROM PAY_ELEMENT_TYPES_F C WHERE C.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID) AND (FF.FORMULA_ID IS NULL OR FF.ROWID IN (SELECT MIN(ROWID) FROM FF_FORMULAS_F C WHERE C.FORMULA_ID = FF.FORMULA_ID))

View Text - HTML Formatted

SELECT A.ENC_ELEMENT_ID
, PIV.NAME INPUT_VALUE
, A.INPUT_VALUE_ID
, FF.FORMULA_NAME
, A.FORMULA_ID
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
, A.ELEMENT_TYPE_CATEGORY
, A.ELEMENT_TYPE_ID
, B.ELEMENT_NAME
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
FROM PSP_ENC_ELEMENTS A
, PAY_ELEMENT_TYPES_F B
, PAY_INPUT_VALUES_F PIV
, FF_FORMULAS_F FF
WHERE A.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
AND PIV.INPUT_VALUE_ID (+) = A.INPUT_VALUE_ID
AND FF.FORMULA_ID (+) = A.FORMULA_ID
AND B.ROWID IN (SELECT MIN(ROWID)
FROM PAY_ELEMENT_TYPES_F C
WHERE C.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID)
AND (FF.FORMULA_ID IS NULL OR FF.ROWID IN (SELECT MIN(ROWID)
FROM FF_FORMULAS_F C
WHERE C.FORMULA_ID = FF.FORMULA_ID))