Product: | PSP - Labor Distribution |
---|---|
Description: | View for setting up elements for labor encumbrance |
Implementation/DBA Data: | APPS.PSP_ENC_ELEMENTS_V |
SELECT A.ENC_ELEMENT_ID
, PIV.NAME INPUT_VALUE
, A.INPUT_VALUE_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
WHERE A.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
AND PIV.INPUT_VALUE_ID = A.INPUT_VALUE_ID
AND B.ROWID IN (SELECT MIN(ROWID)
FROM PAY_ELEMENT_TYPES_F C
WHERE C.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID)