[Home] [Help] [Dependency Information]
Object Name: | PO_ONLINE_REPORT_TEXT# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ONLINE_REPORT_ID | NUMBER | Yes | ||
SEQUENCE | NUMBER | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
TEXT_LINE | VARCHAR2 | (2000) | ||
LINE_NUM | NUMBER | |||
SHIPMENT_NUM | NUMBER | |||
DISTRIBUTION_NUM | NUMBER | |||
TRANSACTION_LEVEL | NUMBER | |||
QUANTITY | NUMBER | |||
TRANSACTION_ID | NUMBER | |||
TRANSACTION_DATE | DATE | |||
TRANSACTION_TYPE | VARCHAR2 | (25) | ||
TRANSACTION_UOM | VARCHAR2 | (25) | ||
TRANSACTION_LOCATION | VARCHAR2 | (60) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
MESSAGE_TYPE | VARCHAR2 | (1) | ||
SHOW_IN_PSA_FLAG | VARCHAR2 | (1) | ||
SEGMENT1 | VARCHAR2 | (20) | ||
DISTRIBUTION_TYPE | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT ONLINE_REPORT_ID
, SEQUENCE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, TEXT_LINE
, LINE_NUM
, SHIPMENT_NUM
, DISTRIBUTION_NUM
, TRANSACTION_LEVEL
, QUANTITY
, TRANSACTION_ID
, TRANSACTION_DATE
, TRANSACTION_TYPE
, TRANSACTION_UOM
, TRANSACTION_LOCATION
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, MESSAGE_TYPE
, SHOW_IN_PSA_FLAG
, SEGMENT1
, DISTRIBUTION_TYPE
FROM PO.PO_ONLINE_REPORT_TEXT#;
|
|
|