Search Results date_submitted




Overview
Explore in AI Chat

Overview

APPS.PSB_WS_FOLDER_V is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered in FND Design Data as PSB.PSB_WS_FOLDER_V. In ETRM (Enterprise Treasury/Public Sector Budgeting) terminology, it presents a consolidated listing of budget worksheets organized within budget groups, exposed in a flat, denormalized form intended to simplify forms coding. The view is flagged as VALID and is classified as a supplementary view whose primary purpose is to reduce the complexity of form-based queries. Oracle explicitly cautions that this view is not a supported integration or reporting interface: the documentation states that querying or altering data through it is not recommended, and that its definition may change dramatically in subsequent minor or major releases.

The view is relevant to the search term date_submitted, which appears as the DATE_SUBMITTED column. This makes PSB_WS_FOLDER_V a convenient source for identifying when a budget worksheet was submitted, together with the submitting user, within the broader context of worksheet staging and budget group structure.

Underlying Base Objects

The documented dependency list identifies the base objects referenced by the view: PSB_WORKSHEETS, PSB_BUDGET_GROUPS, PSB_BUDGET_STAGES, PSB_DATA_EXTRACTS, and FND_USER. These tables supply the worksheet, budget group, stage, data extract, and user information surfaced by the view. The view is documented as not being referenced by any other database object, meaning it functions as a terminal, form-facing presentation layer rather than a shared dependency.

Because it joins the worksheets table with budget groups, stages, and data extracts, the view effectively denormalizes several parent-child relationships into a single row per worksheet folder entry, including derived descriptive columns such as names for groups, stages, extracts, and submitting users.

Key Columns

Common Use Cases and Queries

A typical use is locating worksheets by submission date, or confirming which user submitted a worksheet and when.

SELECT WORKSHEET_ID,
       WORKSHEET_NAME,
       BUDGET_GROUP_SHORT_NAME,
       SUBMITTED_BY_NAME,
       DATE_SUBMITTED,
       SUBMITTED_FLAG
FROM   APPS.PSB_WS_FOLDER_V
WHERE  DATE_SUBMITTED IS NOT NULL
ORDER BY DATE_SUBMITTED DESC;

A second scenario filters worksheets by current stage and freeze status, useful for operational monitoring:

SELECT WORKSHEET_NAME,
       CURRENT_STAGE_NAME,
       FREEZE_FLAG,
       GLOBAL_WORKSHEET_FLAG
FROM   APPS.PSB_WS_FOLDER_V
WHERE  CURRENT_STAGE_NAME = '&stage_name';

Despite its convenience, all access should respect the documented warning: treat this object as an internal forms-support view, avoid persisting dependencies on it, and prefer supported APIs or base tables for production reporting and integration work.