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

TABLE: PO.PO_DOCUMENT_TOTALS_GT

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

Temporary Table Details

PO.PO_DOCUMENT_TOTALS_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$SESSION. 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
KEY NUMBER

LINE_LOCATION_ID NUMBER

AMOUNT_BASED_FLAG VARCHAR2 (1)
SHIPMENT_TYPE VARCHAR2 (25)
PAYMENT_TYPE VARCHAR2 (30)
PRICE NUMBER

QUANTITY_TOTAL NUMBER

QUANTITY_BILLED NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_FINANCED NUMBER

QUANTITY_RECOUPED NUMBER

QUANTITY_RECEIVED NUMBER

QUANTITY_SHIPPED NUMBER

AMOUNT_TOTAL NUMBER

AMOUNT_BILLED NUMBER

AMOUNT_DELIVERED NUMBER

AMOUNT_FINANCED NUMBER

AMOUNT_RECOUPED NUMBER

AMOUNT_RECEIVED NUMBER

AMOUNT_SHIPPED NUMBER

RETAINAGE_WITHHELD_AMOUNT NUMBER

RETAINAGE_RELEASED_AMOUNT NUMBER

Query Text

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


SELECT KEY
,      LINE_LOCATION_ID
,      AMOUNT_BASED_FLAG
,      SHIPMENT_TYPE
,      PAYMENT_TYPE
,      PRICE
,      QUANTITY_TOTAL
,      QUANTITY_BILLED
,      QUANTITY_DELIVERED
,      QUANTITY_FINANCED
,      QUANTITY_RECOUPED
,      QUANTITY_RECEIVED
,      QUANTITY_SHIPPED
,      AMOUNT_TOTAL
,      AMOUNT_BILLED
,      AMOUNT_DELIVERED
,      AMOUNT_FINANCED
,      AMOUNT_RECOUPED
,      AMOUNT_RECEIVED
,      AMOUNT_SHIPPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
FROM PO.PO_DOCUMENT_TOTALS_GT;

Dependencies

[top of page]

PO.PO_DOCUMENT_TOTALS_GT does not reference any database object

PO.PO_DOCUMENT_TOTALS_GT is referenced by following:

SchemaAPPS
SynonymPO_DOCUMENT_TOTALS_GT