Results for “budget_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MSC_GET_NAME is a shared utility package in the Oracle Advanced Supply Chain Planning (ASCP) schema, owned by APPS and classified as OTHER in ETRM. Its business purpose is name resolution: it converts internal numeric identifiers used throughout the MSC planning tables into the human-readable values that planners, reports, and concurrent programs expect to see. Planning data is stored keyed by surrogate IDs — project_id, task_id, organization_id, resource_id, plan_id, and instance_id — and MSC_GET_NAME provides the single, centrally maintained translation layer between those IDs and their descriptive names. Because the package is referenced by 169 other packages, it functions as a foundational dependency across the MSC module rather than an end-user-facing component.
Key Procedures and Functions
The documented interface consists of 156 functions, of which the following are representative of its resolution responsibilities.
- PROJECT, TASK, PLANNING_GROUP, JOB_NAME — return descriptive names for project, task, planning group, and job identifiers within the context of a given organization, plan, and instance.
- ORG_CODE, LOCATION_CODE, INSTANCE_CODE — resolve organization, inventory location, and application instance identifiers to their codes; ORG_CODE is overloaded to accept either a numeric organization ID or an instance-qualified varchar2 form, the latter added for SRP (single resource planning) support.
- DEMAND_DATE, SUPPLY_DATE — return DATE values derived from a pegging identifier and plan, used to present pegging-derived dates without the caller having to join the pegging tables directly.
- RESOURCE_OVER_UTIL_COST — returns a NUMBER for a resource, department, organization, and plan combination.
- LOOKUP_MEANING, LOOKUP_BY_PLAN, FND_LOOKUP_MEANING — translate lookup codes into meanings. LOOKUP_BY_PLAN adds plan-type and source-organization awareness, while FND_LOOKUP_MEANING applies standard FND lookup semantics.
- SUPPLY_ORDER, ORDER_TYPE — resolve supply and order identifiers to their display values.
- PROCESS_PRIORITY — the function associated with the searched term; it resolves a process-priority identifier to its descriptive value, consistent with the package's general naming role.
- WRITE_TO_NUMBER_CACHE, READ_FROM_NUMBER_CACHE, WRITE_TO_STRING_CACHE, READ_FROM_STRING_CACHE — an internal caching mechanism that reduces repeated lookups of the same identifiers during a plan run.
Tables Accessed
MSC_GET_NAME reads from a broad set of ASCP planning tables through APPS synonyms. FND_APPLICATION and FND_LOOKUP_VALUES supply application and lookup meaning data. MSC_APPS_INSTANCES supports instance code resolution. MSC_CALENDAR_DATES underpins date returns. MSC_BOMS and MSC_BOM_COMPONENTS, MSC_DEPARTMENT_RESOURCES, MSC_DESIGNATORS, and MSC_ABC_CLASSES provide name and classification data for bills, resources, and items. MSC_DEMANDS, MSC_DRP_ALLOC_RULES, MSC_DRP_DMD_PRI_RULES, and MSC_EAM_ACT_ASSOCIATIONS support demand, distribution, and asset association resolution. In practice the package is predominantly a read-only resolver against these sources.
Usage Notes
The package is almost never invoked directly by end users. It is called from planning engine code, from other MSC packages (the 169 documented dependents), from Planner Workbench forms and their supporting libraries, and from custom concurrent programs and reports that need to display planning identifiers as names. The internal number and string caches are session-scoped aids, so callers should expect that repeated resolution of the same ID within a single session is served from cache. Custom code should call these functions rather than joining the underlying planning tables directly, so that naming conventions and plan-context logic remain consistent with standard ASCP behavior.
-
PACKAGE: APPS.MSC_GET_NAME 12.1.1
-
PACKAGE: APPS.MSC_GET_NAME 12.2.2
-
View: GL_BUDGETS_CURRENT_V 12.2.2
10SC ONLY
APPS.GL_BUDGETS_CURRENT_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
10SC ONLY
APPS.GL_BUDGETS_NO_JOURNALS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
View: GL_CONS_BUDGET_NAMES_V 12.2.2
10SC ONLY
APPS.GL_CONS_BUDGET_NAMES_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
View: IGI_DOS_BUD_ASS_CAND_V 12.2.2
Based on GL_BUDGET_ASSIGNMENT_RANGES_V, GL_BUDGET_ENTITIES, GL_BUDGETS, BUDGET_VERSIONS, GL_ENTITY_BUDGETS, and GL_CODE_COMBINATIONS_KFV.
APPS.IGI_DOS_BUD_ASS_CAND_V·↳ GL_BUDGETS·↳ GL_BUDGET_ASSIGNMENT_RANGES_V·↳ GL_BUDGET_ENTITIES·Explore IGI module →
-
View: BIS_HR_BUDGETS_V 12.1.1
APPS.BIS_HR_BUDGETS_V·↳ PER_BUDGETS·↳ PER_BUDGET_VERSIONS·↳ PER_BUSINESS_GROUPS·Explore BIS module →
-
10SC ONLY
APPS.GL_BUDGETS_REQUIRE_JOURNALS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
View: GL_BUDGETS_AUTOCOPY_V 12.2.2
10SC ONLY
APPS.GL_BUDGETS_AUTOCOPY_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
Stores budget information
APPS.FV_BUDGETS_WITH_DATES_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore FV module →
-
10SC ONLY
APPS.GL_BUDGETS_REQUIRE_JOURNALS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
View: GLFV_GL_BUDGETS 12.1.1
General Ledger budgets are a collection of estimated amounts for a range of accounting periods.
APPS.GLFV_GL_BUDGETS·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_LEDGERS·Explore GL module →
-
View: GL_CONS_BUDGET_NAMES_V 12.1.1
10SC ONLY
APPS.GL_CONS_BUDGET_NAMES_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
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_SOURCE_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
10SC ONLY
APPS.GL_PERIOD_STATUSES_BUD_UPD_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
View: GL_BUDGETS_CURRENT_V 12.1.1
10SC ONLY
APPS.GL_BUDGETS_CURRENT_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
10SC ONLY
APPS.GL_BUDGETS_SOURCE_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_PERIOD_RANGES·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
View: IGI_DOS_BUD_ASS_CAND_V 12.1.1
Based on GL_BUDGET_ASSIGNMENT_RANGES_V, GL_BUDGET_ENTITIES, GL_BUDGETS, BUDGET_VERSIONS, GL_ENTITY_BUDGETS, and GL_CODE_COMBINATIONS_KFV.
APPS.IGI_DOS_BUD_ASS_CAND_V·↳ GL_BUDGETS·↳ GL_BUDGET_ASSIGNMENT_RANGES_V·↳ GL_BUDGET_ENTITIES·Explore IGI module →
-
View: GL_BUDGETS_NAME_V 12.2.2
10SC ONLY
APPS.GL_BUDGETS_NAME_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
View: GL_BUDGETS_AUTOCOPY_V 12.1.1
10SC ONLY
APPS.GL_BUDGETS_AUTOCOPY_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
View: GL_BUDGETS_NAME_V 12.1.1
10SC ONLY
APPS.GL_BUDGETS_NAME_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
10SC ONLY
APPS.GL_PERIOD_STATUSES_BUD_UPD_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
10SC ONLY
APPS.GL_BUDGETS_NO_JOURNALS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
Contains details for spreadsheet journal headers
-
Contains details for spreadsheet journal headers
-
10SC ONLY
APPS.GL_BUDGETS_TARGET_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
10SC ONLY
APPS.GL_BUDGETS_CONTROL_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·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 →
-
10SC ONLY
APPS.GL_BUDGETS_WITH_DATES_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
10SC ONLY
APPS.GL_BUDGETS_WITH_DATES_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
View: GLBV_GL_BUDGETS 12.1.1
APPS.GLBV_GL_BUDGETS·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
View: GLBV_BUDGET_BALANCES 12.1.1
APPS.GLBV_BUDGET_BALANCES·↳ GL_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·Explore GL module →
-
View: IGC_CBC_SUMMARY_BAL_V 12.2.2
View based on je_lines_bal_all view for Account Inquiry Summaryl Balances block
APPS.IGC_CBC_SUMMARY_BAL_V·↳ GL_ACCOUNT_HIERARCHIES·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·Explore IGC module →
-
10SC ONLY
APPS.GL_BUDGETS_TARGET_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore GL module →
-
10SC ONLY
APPS.GL_BUDGETS_CONTROL_BUDGETS_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
Stores budget information
APPS.FV_BUDGETS_WITH_DATES_V·↳ GL_BUDGETS·↳ GL_BUDGET_VERSIONS·↳ GL_PERIOD_STATUSES·Explore FV module →
-
APPS.IGCFV_CBC_BUDGET_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·↳ GL_SETS_OF_BOOKS·Explore IGC module →
-
View: IGC_CBC_ALL_BAL_V 12.2.2
View based on je_lines_bal_all view for Account Inquiry Balances block
APPS.IGC_CBC_ALL_BAL_V·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·↳ GL_LOOKUPS·Explore IGC module →
-
General Ledger budget assignements are accounts associated with a budget organization.
APPS.GLFV_GL_BUDGET_ASSIGNMENTS·↳ GL_BUDGET_ASSIGNMENTS·↳ GL_BUDGET_ENTITIES·↳ GL_BUDGET_VERSIONS·Explore GL module →
-
Budget definitions
-
Budget definitions
-
View: IGC_CBC_DETAIL_BAL_V 12.2.2
View based on je_lines_bal_all view for Account Inquiry Summaryl Balances block
APPS.IGC_CBC_DETAIL_BAL_V·↳ GL_ACCOUNT_HIERARCHIES·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·Explore IGC module →
-
10SC ONLY
APPS.GL_BUDGET_DEP_BALANCES_V·↳ BUDGET_INQUIRY_PKG·↳ GL_BALANCES·↳ GL_BUDGETS·Explore GL module →
-
View: IGCBV_CBC_BALANCES 12.1.1
APPS.IGCBV_CBC_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·↳ GL_ENCUMBRANCE_TYPES·Explore IGC module →
-
View: IGCBV_CBC_BALANCES 12.2.2
APPS.IGCBV_CBC_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·↳ GL_ENCUMBRANCE_TYPES·Explore IGC module →
-
Budget version definitions
-
View: PQH_BUDGET_DETAILS_V 12.2.2
Budgets Details View
APPS.PQH_BUDGET_DETAILS_V·↳ HR_GENERAL·↳ PER_TIME_PERIODS·↳ PQH_BUDGETS_V·Explore PQH module →