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


TABLE: POA.POA_DBI_NEG_INC

Object Details
Object Name: POA_DBI_NEG_INC
Object Type: TABLE
Owner: POA
Subobject Name:
Status: VALID


Negotiations Fact Incremental Table - truncated every time refresh program is run


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PRIMARY_KEY NUMBER
Yes Primary Key - Auction Header Identifier
BATCH_ID NUMBER
Yes Batch Identifier
TXN_CUR_CODE VARCHAR2 (15)
Transaction Currency Code
FUNC_CUR_CODE VARCHAR2 (15)
Functional Currency Code
RATE_DATE DATE

Rate Date
Query Text

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


SELECT PRIMARY_KEY
,      BATCH_ID
,      TXN_CUR_CODE
,      FUNC_CUR_CODE
,      RATE_DATE
FROM POA.POA_DBI_NEG_INC;

Dependencies

[top of page]

POA.POA_DBI_NEG_INC does not reference any database object

POA.POA_DBI_NEG_INC is referenced by following:

SchemaAPPS
SynonymPOA_DBI_NEG_INC