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

TABLE: ZX.ZX_PO_REC_DIST

Object Details
Object Name: ZX_PO_REC_DIST
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_PO_REC_DIST
Subobject Name:
Status: VALID

Temporary Table Details

ZX.ZX_PO_REC_DIST is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
ZX_PO_REC_DIST_N1 NORMAL NONUNIQUE Tablespace ColumnPO_LINE_LOCATION_ID
ColumnPO_HEADER_ID
ColumnTAX_RATE_ID
Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER

Purchase order header identifier
PO_LINE_LOCATION_ID NUMBER

Purchase order shipment schedule identifier
PO_DISTRIBUTION_ID NUMBER

Purchase order distribution identifier
REC_RATE NUMBER

Calculated tax recovery rate
TAX_RATE_ID NUMBER

Tax code identifier
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT PO_HEADER_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      REC_RATE
,      TAX_RATE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZX.ZX_PO_REC_DIST;

Dependencies

[top of page]

ZX.ZX_PO_REC_DIST does not reference any database object

ZX.ZX_PO_REC_DIST is referenced by following:

SchemaAPPS
SynonymZX_PO_REC_DIST