VIEW: APPS.PSBBV_POSITION_SET_LISTS

Source

View Text - Preformatted

SELECT st.name ,dt.data_extract_name ,ps.name ,po.account_position_set_id ,po.data_extract_id ,po.position_id ,po.LAST_UPDATE_DATE ,po.LAST_UPDATED_BY ,po.CREATED_BY ,po.CREATION_DATE FROM psb_budget_positions po, psb_positions ps, psb_data_extracts dt, psb_account_position_sets st WHERE po.position_id = ps.position_id AND dt.data_extract_id = ps.data_extract_id AND st.account_position_set_id = po.account_position_set_id with read only

View Text - HTML Formatted

SELECT ST.NAME
, DT.DATA_EXTRACT_NAME
, PS.NAME
, PO.ACCOUNT_POSITION_SET_ID
, PO.DATA_EXTRACT_ID
, PO.POSITION_ID
, PO.LAST_UPDATE_DATE
, PO.LAST_UPDATED_BY
, PO.CREATED_BY
, PO.CREATION_DATE
FROM PSB_BUDGET_POSITIONS PO
, PSB_POSITIONS PS
, PSB_DATA_EXTRACTS DT
, PSB_ACCOUNT_POSITION_SETS ST
WHERE PO.POSITION_ID = PS.POSITION_ID
AND DT.DATA_EXTRACT_ID = PS.DATA_EXTRACT_ID
AND ST.ACCOUNT_POSITION_SET_ID = PO.ACCOUNT_POSITION_SET_ID WITH READ ONLY