[Home] [Help] [Dependency Information]
Object Name: | PON_ACTION_HISTORY# |
---|---|
Object Type: | VIEW |
Owner: | PON |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | Yes | ||
OBJECT_ID2 | NUMBER | Yes | ||
OBJECT_TYPE_CODE | VARCHAR2 | (25) | Yes | |
SEQUENCE_NUM | NUMBER | Yes | ||
ACTION_TYPE | VARCHAR2 | (25) | Yes | |
ACTION_DATE | DATE | Yes | ||
ACTION_USER_ID | NUMBER | Yes | ||
ACTION_NOTE | VARCHAR2 | (2000) | ||
ACTION_REASON_CODE | VARCHAR2 | (25) | ||
USER_NAME | VARCHAR2 | (100) | ||
FILE_ID | NUMBER | |||
REQUESTED_FOR_TPC_ID | NUMBER | |||
SIGNED_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, OBJECT_ID2
, OBJECT_TYPE_CODE
, SEQUENCE_NUM
, ACTION_TYPE
, ACTION_DATE
, ACTION_USER_ID
, ACTION_NOTE
, ACTION_REASON_CODE
, USER_NAME
, FILE_ID
, REQUESTED_FOR_TPC_ID
, SIGNED_DATE
FROM PON.PON_ACTION_HISTORY#;
|
|
|