DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PQH_CMMTMNT_ENTITIES_V

Object Details
Object Name: PQH_CMMTMNT_ENTITIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPQH.PQH_CMMTMNT_ENTITIES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15)
BUDGET_ID NUMBER (15)
BUDGET_DATE_FROM DATE

BUDGET_DATE_TO DATE

BUDGET_VERSION_ID NUMBER (15)
VERSION_FROM_DATE DATE

VERSION_TO_DATE DATE

BUDGET_DETAIL_ID NUMBER (15)
BUDGET_UNIT1_ID NUMBER (15)
BUDGET_UNIT1_NAME VARCHAR2 (4000)
BUDGET_UNIT2_ID NUMBER (15)
BUDGET_UNIT2_NAME VARCHAR2 (4000)
BUDGET_UNIT3_ID NUMBER (15)
BUDGET_UNIT3_NAME VARCHAR2 (4000)
BUDGETED_ENTITY_CD VARCHAR2 (30)
BUDGETED_ENTITY_NAME VARCHAR2 (4000)
ENTITY_ID NUMBER (15)
ENTITY_NAME VARCHAR2 (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUSINESS_GROUP_ID
,      BUDGET_ID
,      BUDGET_DATE_FROM
,      BUDGET_DATE_TO
,      BUDGET_VERSION_ID
,      VERSION_FROM_DATE
,      VERSION_TO_DATE
,      BUDGET_DETAIL_ID
,      BUDGET_UNIT1_ID
,      BUDGET_UNIT1_NAME
,      BUDGET_UNIT2_ID
,      BUDGET_UNIT2_NAME
,      BUDGET_UNIT3_ID
,      BUDGET_UNIT3_NAME
,      BUDGETED_ENTITY_CD
,      BUDGETED_ENTITY_NAME
,      ENTITY_ID
,      ENTITY_NAME
FROM APPS.PQH_CMMTMNT_ENTITIES_V;

Dependencies

[top of page]

APPS.PQH_CMMTMNT_ENTITIES_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPQH_BUDGETS
SynonymPQH_BUDGET_DETAILS
SynonymPQH_BUDGET_VERSIONS
APPS.PQH_CMMTMNT_ENTITIES_V is referenced by following:

SchemaAPPS
Package BodyPQH_COMMITMENT_PKG - show dependent code
ViewPQH_ENTITY_ELEMENT_TYPES_V