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

TABLE: PO.PO_ONLINE_REPORT_TEXT

Object Details
Object Name: PO_ONLINE_REPORT_TEXT
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_ONLINE_REPORT_TEXT
Subobject Name:
Status: VALID


PO_ONLINE_REPORT_TEXT contains information about purchasing
documents that fail the approval, cancel, or final-close
submission checks. There is one record in the table for each
error detected during the submission check. Each row includes
the error that was detected and the document entity that the error
is associated with.
.
ONLINE_REPORT_ID is the unique system-generated identifier that is
invisible
to the user.
.
Oracle Purchasing uses the online report when submitting a
purchase order or requisition to the approval process,
cancelling a purchase order, or final-closing a purchase order.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_ONLINE_REPORT_TEXT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnONLINE_REPORT_ID
Columns
Name Datatype Length Mandatory Comments
ONLINE_REPORT_ID NUMBER
Yes Online report unique identifier
SEQUENCE NUMBER
Yes Sequence of the online report message
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TEXT_LINE VARCHAR2 (2000)
Online report message
LINE_NUM NUMBER

Requisition or purchase order line that message references
SHIPMENT_NUM NUMBER

Purchase orders shipment that message references
DISTRIBUTION_NUM NUMBER

Requisition or purchase order distribution that message references
TRANSACTION_LEVEL NUMBER

No longer used
QUANTITY NUMBER

No longer used
TRANSACTION_ID NUMBER

No longer used
TRANSACTION_DATE DATE

No longer used
TRANSACTION_TYPE VARCHAR2 (25)
No longer used
TRANSACTION_UOM VARCHAR2 (25)
No longer used
TRANSACTION_LOCATION VARCHAR2 (60)
No longer used
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
MESSAGE_TYPE VARCHAR2 (1)
Indicates whether this message is a warning ('W') or an error ('E' or null).
SHOW_IN_PSA_FLAG VARCHAR2 (1)
show in psa flag
SEGMENT1 VARCHAR2 (20)
Key flexfield segment
DISTRIBUTION_TYPE VARCHAR2 (25)
Distribution Type
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 does not reference any database object

PO.PO_ONLINE_REPORT_TEXT is referenced by following:

SchemaAPPS
SynonymPO_ONLINE_REPORT_TEXT