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

TABLE: FTE.FTE_PTRK_PAGES

Object Details
Object Name: FTE_PTRK_PAGES
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_PTRK_PAGES
Subobject Name:
Status: VALID


Table to store tracking header information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_PTRK_PAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAGE_ID
FTE_PTRK_PAGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCARRIER_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PAGE_ID NUMBER (15) Yes Page id
OWNER_APPLICATION_ID NUMBER (15) Yes Owner application id
ORGANIZATIONS VARCHAR2 (2000)
Organization names
CARRIER_PARTY_ID NUMBER (15) Yes Carrier id populated based on carrier_id in wsh_carriers
BASE_URL VARCHAR2 (200) Yes Base Url
REQUEST_METHOD VARCHAR2 (4) Yes Request method
STATUS VARCHAR2 (20)
Status of progress
NAME VARCHAR2 (30)
Page name
DESCRIPTION VARCHAR2 (200)
Page description
BUSINESS_CONCEPTS VARCHAR2 (1000)
Business concept
GRANULARITY VARCHAR2 (20)
Granularity
CREATED_BY NUMBER
Yes Standard who columns
CREATION_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER
Yes Standard who columns
LAST_UPDATE_DATE DATE
Yes Standard who columns
LAST_UPDATE_LOGIN NUMBER

Standard who columns
Query Text

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


SELECT PAGE_ID
,      OWNER_APPLICATION_ID
,      ORGANIZATIONS
,      CARRIER_PARTY_ID
,      BASE_URL
,      REQUEST_METHOD
,      STATUS
,      NAME
,      DESCRIPTION
,      BUSINESS_CONCEPTS
,      GRANULARITY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FTE.FTE_PTRK_PAGES;

Dependencies

[top of page]

FTE.FTE_PTRK_PAGES does not reference any database object

FTE.FTE_PTRK_PAGES is referenced by following:

SchemaAPPS
SynonymFTE_PTRK_PAGES