VIEW: APPS.PSB_GL_BUDGETS_V

Source

View Text - Preformatted

SELECT pb.rowid ,pb.gl_budget_id ,pb.gl_budget_set_id ,pb.gl_budget_version_id ,pb.start_period ,pb.end_period ,pb.start_date ,pb.end_date ,pb.dual_posting_type ,pb.last_update_date ,pb.last_updated_by ,pb.last_update_login ,pb.created_by ,pb.creation_date ,gb.budget_name ,gb.start_date ,gb.end_date FROM psb_gl_budgets pb, gl_budgets_v gb WHERE pb.gl_budget_version_id = gb.budget_version_id

View Text - HTML Formatted

SELECT PB.ROWID
, PB.GL_BUDGET_ID
, PB.GL_BUDGET_SET_ID
, PB.GL_BUDGET_VERSION_ID
, PB.START_PERIOD
, PB.END_PERIOD
, PB.START_DATE
, PB.END_DATE
, PB.DUAL_POSTING_TYPE
, PB.LAST_UPDATE_DATE
, PB.LAST_UPDATED_BY
, PB.LAST_UPDATE_LOGIN
, PB.CREATED_BY
, PB.CREATION_DATE
, GB.BUDGET_NAME
, GB.START_DATE
, GB.END_DATE
FROM PSB_GL_BUDGETS PB
, GL_BUDGETS_V GB
WHERE PB.GL_BUDGET_VERSION_ID = GB.BUDGET_VERSION_ID