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

VIEW: APPS.PABV_ORGANIZATIONS

Object Details
Object Name: PABV_ORGANIZATIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PABV_ORGANIZATIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
ORGANIZATION_NAME VARCHAR2 (240) Yes
DATE_FROM DATE
Yes
DATE_TO DATE

INTERNAL_ADDRESS_LINE VARCHAR2 (80)
COMMENTS CLOB (4000)
INTERNAL_EXTERNAL_FLAG VARCHAR2 (4000)
TYPE VARCHAR2 (4000)
LOCATION_NAME VARCHAR2 (60)
ORGANIZATION_USE_TYPE_CODE VARCHAR2 (30) Yes
ORG_USE_TYPE VARCHAR2 (80) Yes
INACTIVE_DATE DATE

_DF CHAR (34)
BUSINESS_GROUP_ID NUMBER (15) Yes
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
LOCATION_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15) Yes
ORG_ID NUMBER

SOFT_CODING_KEYFLEX_ID NUMBER (15)
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      ORGANIZATION_NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_ADDRESS_LINE
,      COMMENTS
,      INTERNAL_EXTERNAL_FLAG
,      TYPE
,      LOCATION_NAME
,      ORGANIZATION_USE_TYPE_CODE
,      ORG_USE_TYPE
,      INACTIVE_DATE
,      _DF
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      ORG_ID
,      SOFT_CODING_KEYFLEX_ID
FROM APPS.PABV_ORGANIZATIONS;

Dependencies

[top of page]

APPS.PABV_ORGANIZATIONS references the following:

SchemaAPPS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
SynonymPA_ALL_ORGANIZATIONS
SynonymPA_IMPLEMENTATIONS_ALL

APPS.PABV_ORGANIZATIONS is not referenced by any database object