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


VIEW: APPS.PAYBV_US_STATES_V

Object Details
Object Name: PAYBV_US_STATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAYBV_US_STATES_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
STATE_CODE VARCHAR2 (2) Yes State geocode.
STATE_ABBREV VARCHAR2 (2) Yes Abbreviation for state, eg. CA.
STATE_NAME VARCHAR2 (25) Yes State name.
Query Text

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


SELECT STATE_CODE
,      STATE_ABBREV
,      STATE_NAME
FROM APPS.PAYBV_US_STATES_V;

Dependencies

[top of page]

APPS.PAYBV_US_STATES_V references the following:

SchemaAPPS
SynonymPAY_US_STATES

APPS.PAYBV_US_STATES_V is not referenced by any database object