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

TABLE: POS.POS_PO_REVISIONS_GT

Object Details
Object Name: POS_PO_REVISIONS_GT
Object Type: TABLE
Owner: POS
Subobject Name:
Status: VALID

Temporary Table Details

POS.POS_PO_REVISIONS_GT 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$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
LINE_SEQ NUMBER
Yes
CREATION_DATE DATE
Yes
HEADER_ID NUMBER
Yes
RELEASE_ID NUMBER

LINE_ID NUMBER

LOCATION_ID NUMBER

DISTRIBUTION_ID NUMBER

ITEM_ID NUMBER

PO_NUM VARCHAR2 (80)
REVISION_NUM NUMBER
Yes
LINE_NUM NUMBER

LOCATION_NUM NUMBER

DISTRIBUTION_NUM NUMBER

LEVEL_ALTERED VARCHAR2 (40) Yes
FIELD_ALTERED VARCHAR2 (40) Yes
CHANGES_FROM VARCHAR2 (2000)
CHANGES_TO VARCHAR2 (2000)
ENABLED_ORG_NAME VARCHAR2 (240)
PRICE_DIFF_NUM NUMBER

CHANGE_FROM_DATE DATE

CHANGE_TO_DATE DATE

ITEM VARCHAR2 (2000)
JOB VARCHAR2 (700)
Query Text

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


SELECT LINE_SEQ
,      CREATION_DATE
,      HEADER_ID
,      RELEASE_ID
,      LINE_ID
,      LOCATION_ID
,      DISTRIBUTION_ID
,      ITEM_ID
,      PO_NUM
,      REVISION_NUM
,      LINE_NUM
,      LOCATION_NUM
,      DISTRIBUTION_NUM
,      LEVEL_ALTERED
,      FIELD_ALTERED
,      CHANGES_FROM
,      CHANGES_TO
,      ENABLED_ORG_NAME
,      PRICE_DIFF_NUM
,      CHANGE_FROM_DATE
,      CHANGE_TO_DATE
,      ITEM
,      JOB
FROM POS.POS_PO_REVISIONS_GT;

Dependencies

[top of page]

POS.POS_PO_REVISIONS_GT does not reference any database object

POS.POS_PO_REVISIONS_GT is referenced by following:

SchemaAPPS
SynonymPOS_PO_REVISIONS_GT