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

VIEW: APPS.PA_IMP_EXP_HIERARCHY_V

Object Details
Object Name: PA_IMP_EXP_HIERARCHY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_IMP_EXP_HIERARCHY_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) Yes Business Group Identifier of the Implementation
ORG_ID NUMBER (15) Yes Operating Unit of the Implementation
EXP_ORG_STRUCTURE_ID NUMBER
Yes Expenditure Owning Hierarchy Identifier of the Implementation
EXP_ORG_STRUCTURE_NAME VARCHAR2 (30) Yes Expenditure Owning Hierarchy Name of the Implementation
EXP_ORG_STRUCTURE_VERSION_ID NUMBER
Yes Hierarchy Version Identifier of the Implementation
EXP_START_ORG_ID NUMBER
Yes Start Org Identifier of the Expenditure Hierarchy of the Implementation
EXP_START_ORG_NAME VARCHAR2 (240) Yes Start Org Name of the Expenditure Hierarchy of the Implementation
Query Text

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


SELECT BUSINESS_GROUP_ID
,      ORG_ID
,      EXP_ORG_STRUCTURE_ID
,      EXP_ORG_STRUCTURE_NAME
,      EXP_ORG_STRUCTURE_VERSION_ID
,      EXP_START_ORG_ID
,      EXP_START_ORG_NAME
FROM APPS.PA_IMP_EXP_HIERARCHY_V;

Dependencies

[top of page]

APPS.PA_IMP_EXP_HIERARCHY_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_IMPLEMENTATIONS
SynonymPER_ORGANIZATION_STRUCTURES

APPS.PA_IMP_EXP_HIERARCHY_V is not referenced by any database object