Skip to content

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

VIEW: PO.PO_ONLINE_REPORT_TEXT#

Object Details
Object Name: PO_ONLINE_REPORT_TEXT#
Object Type: VIEW
Owner: PO
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

PO.PO_ONLINE_REPORT_TEXT# references the following:

SchemaPO
TablePO_ONLINE_REPORT_TEXT
PO.PO_ONLINE_REPORT_TEXT# is referenced by following:

SchemaAPPS
SynonymPO_ONLINE_REPORT_TEXT