Results for “start_period_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GL_BUDGETS_TARGET_BUDGETS_V is a General Ledger (GL) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented in ETRM as "10SC ONLY," indicating the view exists to support a specific localized or downstream reporting requirement rather than the core General Ledger budget maintenance screens. The view joins budget definitions to their budget versions and to the period status records that mark the budget's active range, exposing both the starting and ending period of each budget in a single queryable row.
Its purpose is to present target budget scope information: for a given ledger and budget name, it delivers the descriptive text, the budget version identifier, and the calendar periods that bound the budget. Because both the start and end periods are resolved from GL_PERIOD_STATUSES, the view is useful wherever a report or interface must determine the exact period window over which a budget is valid without performing those lookups manually.
Underlying Base Objects
The view is defined over four sources, all referenced through APPS synonyms: GL_BUDGETS, GL_BUDGET_VERSIONS, and GL_PERIOD_STATUSES (used twice, aliased PS1 and PS2).
- GL_BUDGETS (B) supplies the budget description, ledger identifier, and the first and last valid period names that define the budget's range.
- GL_BUDGET_VERSIONS (BV) supplies the budget name and the budget_version_id, joined to GL_BUDGETS on budget_name.
- GL_PERIOD_STATUSES PS1 resolves the first valid period name into a period number and period year, filtered to application_id 101 (General Ledger) and matched on ledger_id.
- GL_PERIOD_STATUSES PS2 performs the equivalent resolution for the last valid period name.
The join therefore requires that periods for both the start and end of the budget exist in GL_PERIOD_STATUSES for the same ledger and for the GL application. If either period is absent, no row is returned for that budget.
Key Columns
- BUDGET_NAME – the budget identifier from GL_BUDGET_VERSIONS, joined to GL_BUDGETS on the same column.
- BUDGET_VERSION_ID – the unique version identifier associated with the budget.
- DESCRIPTION – the descriptive text of the budget from GL_BUDGETS.
- LEDGER_ID – the ledger to which the budget and periods belong.
- START_PERIOD_NAME, START_PERIOD_NUM, START_PERIOD_YEAR – the first valid period, expressed as name, number, and accounting year. The user's search term, start_period_year, corresponds to the accounting year of the budget's opening period.
- END_PERIOD_NAME, END_PERIOD_NUM, END_PERIOD_YEAR – the last valid period, expressed in the same three attributes.
Common Use Cases and Queries
Typical scenarios include identifying budgets that begin or end in a particular accounting year, validating that a budget covers a requested reporting range, and populating interfaces that require the period window alongside the budget name and version.
- List budgets whose opening period falls in a given year:
SELECT budget_name, budget_version_id, description, ledger_id, start_period_name, start_period_year FROM gl_budgets_target_budgets_v WHERE start_period_year = 2013; - Restrict to a single ledger and order by the opening period:
SELECT budget_name, start_period_name, end_period_name FROM gl_budgets_target_budgets_v WHERE ledger_id = 1 ORDER BY start_period_year, start_period_num; - Find budgets active across a period range:
SELECT budget_name, budget_version_id FROM gl_budgets_target_budgets_v WHERE start_period_num <= :p_start_num AND end_period_num >= :p_end_num;
The last query is efficient because multi-table joins are resolved in the view definition, so callers simply filter or sort on the exposed period columns such as start_period_year rather than joining the underlying GL tables themselves.
-
10SC ONLY
APPS.GL_BUDGETS_TARGET_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
Status of budget period ranges (open/not open)
-
Status of budget period ranges (open/not open)
-
View: GL_BUD_PERIOD_RANGES_V 12.2.2
10SC ONLY
APPS.GL_BUD_PERIOD_RANGES_V·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
10SC ONLY
APPS.GL_BUDGETS_TARGET_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
View: GL_BUD_PERIOD_RANGES_V 12.1.1
10SC ONLY
APPS.GL_BUD_PERIOD_RANGES_V·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
This view is created for giving general information about progam Components
APPS.AMS_PROGRAM_COMPONENTS_V·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_VL·↳ AMS_EVENT_HEADERS_VL·Explore AMS module →
-
Stores information which determines the statistical type data for each legal entity.
-
This table stores the parameters and defaults that define the various options for forecasting options. If you have a multi-organization installation, you define one row for each operating unit.
-
Interface table used for uploading and downing hierarchies
-
Interface table used for uploading and downing hierarchies
-
Stores information which determines the statistical type data for each legal entity.
-
View: OZF_THRESHOLDS 12.2.2
Threshold definition
APPS.OZF_THRESHOLDS·↳ OZF_THRESHOLDS_ALL_B·Explore OZF module →
-
View: OZF_THRESHOLDS 12.1.1
Threshold definition
APPS.OZF_THRESHOLDS·↳ OZF_THRESHOLDS_ALL_B·Explore OZF module →
-
Used in Create/View/Edit Versions OA page This view retrieves information about a budget version when a budget version id is not supplied. It relies on the following packages: pa_fin_plan_create_ver_global.
APPS.PA_FIN_PLAN_CREATE_PLAN_NOBV_V·↳ PA_FIN_PLAN_CREATE_VER_GLOBAL·↳ PA_FIN_PLAN_TYPES_VL·↳ PA_PROJ_FP_OPTIONS·Explore PA module →
-
Holds information on Funds Thresholds.
-
View: MTL_STAT_TYPE_USAGES_V 12.1.1
Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic Zones View and Hr Locations
APPS.MTL_STAT_TYPE_USAGES_V·↳ GL_PERIOD_TYPES·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore INV module →
-
View: OZF_THRESHOLDS_VL 12.2.2
APPS.OZF_THRESHOLDS_VL·↳ OZF_THRESHOLDS_ALL_B·↳ OZF_THRESHOLDS_ALL_TL·Explore OZF module →
-
This view is created for giving general information about progam Components
APPS.AMS_PROGRAM_COMPONENTS_V·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_VL·↳ AMS_EVENT_HEADERS_VL·Explore AMS module →
-
This stores the dialog object
-
This public view returns the campaign schedule information..
APPS.AMS_P_CAMPAIGN_SCHEDS_V·↳ AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_CHANNELS_TL·Explore AMS module →
-
View: OZF_THRESHOLD_RULES 12.1.1
APPS.OZF_THRESHOLD_RULES·↳ OZF_THRESHOLD_RULES_ALL·Explore OZF module →
-
Used in Create/View/Edit Versions OA page. This view retrieves information about a budget version given a budget version id. It relies on the following packages: pa_fin_plan_create_ver_global.
APPS.PA_FIN_PLAN_CREATE_PLAN_BV_V·↳ PA_BUDGET_VERSIONS·↳ PA_FIN_PLAN_CREATE_VER_GLOBAL·↳ PA_FIN_PLAN_TYPES_VL·Explore PA module →
-
Used in Create/View/Edit Versions OA page. This view retrieves information about a budget version given a budget version id. It relies on the following packages: pa_fin_plan_create_ver_global.
APPS.PA_FIN_PLAN_CREATE_PLAN_BV_V·↳ PA_BUDGET_VERSIONS·↳ PA_FIN_PLAN_CREATE_VER_GLOBAL·↳ PA_FIN_PLAN_TYPES_VL·Explore PA module →
-
This table stores the parameters and defaults that define the various options for forecasting options. If you have a multi-organization installation, you define one row for each operating unit.
-
View: OZF_THRESHOLD_RULES 12.2.2
APPS.OZF_THRESHOLD_RULES·↳ OZF_THRESHOLD_RULES_ALL·Explore OZF module →
-
Used in Create/View/Edit Versions OA page This view retrieves information about a budget version when a budget version id is not supplied. It relies on the following packages: pa_fin_plan_create_ver_global.
APPS.PA_FIN_PLAN_CREATE_PLAN_NOBV_V·↳ PA_FIN_PLAN_CREATE_VER_GLOBAL·↳ PA_FIN_PLAN_TYPES_VL·↳ PA_PROJ_FP_OPTIONS·Explore PA module →
-
View: OZF_THRESHOLDS_VL 12.1.1
APPS.OZF_THRESHOLDS_VL·↳ OZF_THRESHOLDS_ALL_B·↳ OZF_THRESHOLDS_ALL_TL·Explore OZF module →
-
View: OZF_THRESHOLDS_ALL_VL 12.1.1
APPS.OZF_THRESHOLDS_ALL_VL·↳ OZF_THRESHOLDS_ALL_B·↳ OZF_THRESHOLDS_ALL_TL·Explore OZF module →
-
View: AMS_EVENT_HEADERS_V 12.2.2
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_LOOKUPS·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
View: AMS_P_DELIVERABLES_V 12.2.2
This public view returns the marketing deliverable information.
APPS.AMS_P_DELIVERABLES_V·↳ AMS_CATEGORIES_TL·↳ AMS_DELIVERABLES_VL·↳ AMS_JTF_RS_EMP_V·Explore AMS module →
-
Holds information on Funds Thresholds.
-
View: MTL_STAT_TYPE_USAGES_V 12.2.2
Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic Zones View and Hr Locations
APPS.MTL_STAT_TYPE_USAGES_V·↳ GL_PERIOD_TYPES·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore INV module →
-
View: OZF_FUNDS 12.1.1
-
View: OZF_THRESHOLDS_ALL_VL 12.2.2
APPS.OZF_THRESHOLDS_ALL_VL·↳ OZF_THRESHOLDS_ALL_B·↳ OZF_THRESHOLDS_ALL_TL·Explore OZF module →
-
This is the view for marketing campaign Schedules.
APPS.AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_CAMPAIGN_SCHEDULES_B·↳ AMS_CAMPAIGN_SCHEDULES_TL·Explore AMS module →
-
This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version.
-
View: OZF_FUNDS 12.2.2
-
APPS.AMS_DELIVERABLES_INFO_V·↳ AMS_CATEGORIES_TL·↳ AMS_DELIVERABLES_VL·↳ AMS_JTF_RS_EMP_V·Explore AMS module →
-
View: AMS_CAMPAIGNS_V 12.1.1
This view returns all marketing campaigns and related information.
APPS.AMS_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_ALL_TL·↳ AMS_CAMPAIGNS_VL·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
View: OZF_FUNDS_VL 12.1.1
Fund setup master base table and translation table view.
APPS.OZF_FUNDS_VL·↳ OZF_FUNDS_ALL_B·↳ OZF_FUNDS_ALL_TL·Explore OZF module →
-
View: AMS_P_CAMPAIGNS_V 12.2.2
This public view returns all marketing campaigns and related information.
APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →
-
View: AMS_P_CAMPAIGNS_V 12.1.1
This public view returns all marketing campaigns and related information.
APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →
-
This stores the dialog object
-
Stores the definition of a Marketing Event. (Master Event or Event Template)
-
Holds Funds Threshold Rule Information.
-
Holds Funds Threshold Rule Information.
-
View: OKI_SALES_K_HEADERS_V 12.1.1
Information about contracts with the sell intent.
APPS.OKI_SALES_K_HEADERS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore OKI module →
-
This public view returns the campaign schedule information..
APPS.AMS_P_CAMPAIGN_SCHEDS_V·↳ AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_CHANNELS_TL·Explore AMS module →
-
This table stores the value for budget or quota allocation