VIEW: APPS.PSBFV_WS_ELEMENT_COST_LINES

Source

View Text - Preformatted

SELECT POS.NAME, SP.SHORT_NAME, EL.NAME, BP.NAME, WEL.ELEMENT_COST, WEL.START_STAGE_SEQ, WEL.CURRENT_STAGE_SEQ, WEL.END_STAGE_SEQ, WEL.POSITION_LINE_ID, WEL.SERVICE_PACKAGE_ID, WEL.PAY_ELEMENT_ID, WEL.BUDGET_YEAR_ID, WEL.ELEMENT_LINE_ID, WEL.LAST_UPDATE_DATE, WEL.LAST_UPDATED_BY, WEL.CREATED_BY, WEL.CREATION_DATE from PSB_WS_ELEMENT_LINES WEL, PSB_WS_POSITION_LINES WPL, PSB_POSITIONS POS, PSB_PAY_ELEMENTS EL, PSB_BUDGET_PERIODS BP, PSB_SERVICE_PACKAGES SP where WEL.position_line_id = WPL.position_line_id and WPL.position_id = POS.position_id and EL.pay_element_id = WEL.pay_element_id and BP.budget_period_id = WEL.budget_year_id and SP.service_package_id = WEL.service_package_id with read only

View Text - HTML Formatted

SELECT POS.NAME
, SP.SHORT_NAME
, EL.NAME
, BP.NAME
, WEL.ELEMENT_COST
, WEL.START_STAGE_SEQ
, WEL.CURRENT_STAGE_SEQ
, WEL.END_STAGE_SEQ
, WEL.POSITION_LINE_ID
, WEL.SERVICE_PACKAGE_ID
, WEL.PAY_ELEMENT_ID
, WEL.BUDGET_YEAR_ID
, WEL.ELEMENT_LINE_ID
, WEL.LAST_UPDATE_DATE
, WEL.LAST_UPDATED_BY
, WEL.CREATED_BY
, WEL.CREATION_DATE
FROM PSB_WS_ELEMENT_LINES WEL
, PSB_WS_POSITION_LINES WPL
, PSB_POSITIONS POS
, PSB_PAY_ELEMENTS EL
, PSB_BUDGET_PERIODS BP
, PSB_SERVICE_PACKAGES SP
WHERE WEL.POSITION_LINE_ID = WPL.POSITION_LINE_ID
AND WPL.POSITION_ID = POS.POSITION_ID
AND EL.PAY_ELEMENT_ID = WEL.PAY_ELEMENT_ID
AND BP.BUDGET_PERIOD_ID = WEL.BUDGET_YEAR_ID
AND SP.SERVICE_PACKAGE_ID = WEL.SERVICE_PACKAGE_ID WITH READ ONLY