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

TABLE: PO.PO_HEADERS_ALL_EBS

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


PO_HEADERS_ALL_EBS holds data in original sob currency before the euro switch


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_HEADERS_ALL_EBS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPO_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes PO Header Identifier
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Type Lookup Code
SEGMENT1 VARCHAR2 (25) Yes Key flexfield segment
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORG_ID NUMBER

Organization identifier
CURRENCY_CODE VARCHAR2 (15)
Currency Code
BLANKET_TOTAL_AMOUNT NUMBER

Blanket Total Amount
AMOUNT_LIMIT NUMBER

Amount Limit
MIN_RELEASE_AMOUNT NUMBER

Min Release Amount
RATE NUMBER

Rate
RATE_TYPE VARCHAR2 (30)
Rate Type
RATE_DATE DATE

Rate Date
EURO_PO_HEADER_ID NUMBER

Euro PO Header Identifier
EURO_SEGMENT1 VARCHAR2 (25)
Euro Segment1
SECURITY_GROUP_ID NUMBER

security group identifier
Query Text

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


SELECT PO_HEADER_ID
,      TYPE_LOOKUP_CODE
,      SEGMENT1
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
,      CURRENCY_CODE
,      BLANKET_TOTAL_AMOUNT
,      AMOUNT_LIMIT
,      MIN_RELEASE_AMOUNT
,      RATE
,      RATE_TYPE
,      RATE_DATE
,      EURO_PO_HEADER_ID
,      EURO_SEGMENT1
,      SECURITY_GROUP_ID
FROM PO.PO_HEADERS_ALL_EBS;

Dependencies

[top of page]

PO.PO_HEADERS_ALL_EBS does not reference any database object

PO.PO_HEADERS_ALL_EBS is referenced by following:

SchemaPO
ViewPO_HEADERS_ALL_EBS#