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

VIEW: APPS.POFV_UN_NUMBERS

Object Details
Object Name: POFV_UN_NUMBERS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POFV_UN_NUMBERS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about the United Nations hazardous material classification number.


[View Source]

Columns
Name Datatype Length Mandatory Comments
UN_NUMBER_ID NUMBER
Yes
UN_NUMBER VARCHAR2 (25) Yes
DESCRIPTION VARCHAR2 (240) Yes
INACTIVE_DATE DATE


_DF CHAR (23)

HAZARD_CLASS_ID NUMBER


HAZARD_CLASS VARCHAR2 (40)

CREATED_DATE DATE


CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT UN_NUMBER_ID
,      UN_NUMBER
,      DESCRIPTION
,      INACTIVE_DATE
,      _DF
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.POFV_UN_NUMBERS;

Dependencies

[top of page]

APPS.POFV_UN_NUMBERS references the following:

SchemaAPPS
SynonymPO_HAZARD_CLASSES
SynonymPO_UN_NUMBERS

APPS.POFV_UN_NUMBERS is not referenced by any database object