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

TABLE: PO.RCV_FTE_TRANSACTION_LINES

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


This table aggregates receiving transactions that are relevant to transportation logistics.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCV_FTE_TRANSACTION_LINES_V1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnACTION
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Header Identifier
LINE_ID NUMBER

Line Identifier
ACTION VARCHAR2 (255) Yes Action flag
REPORTED_FLAG VARCHAR2 (1) Yes Reported Flag
TRANSACTION_ID NUMBER

Transaction Identifier
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).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created 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.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT HEADER_ID
,      LINE_ID
,      ACTION
,      REPORTED_FLAG
,      TRANSACTION_ID
,      REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PO.RCV_FTE_TRANSACTION_LINES;

Dependencies

[top of page]

PO.RCV_FTE_TRANSACTION_LINES does not reference any database object

PO.RCV_FTE_TRANSACTION_LINES is referenced by following:

SchemaPO
ViewRCV_FTE_TRANSACTION_LINES#