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

VIEW: FTE.FTE_MESSAGE_PARTNER#

Object Details
Object Name: FTE_MESSAGE_PARTNER#
Object Type: VIEW
Owner: FTE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
NAME1 VARCHAR2 (50)
NAME2 VARCHAR2 (50)
NAME3 VARCHAR2 (50)
NAME4 VARCHAR2 (50)
NAME5 VARCHAR2 (50)
NAME6 VARCHAR2 (50)
NAME7 VARCHAR2 (50)
NAME8 VARCHAR2 (50)
NAME9 VARCHAR2 (50)
ONETIME VARCHAR2 (50)
PARTNER_ID NUMBER

PARTNER_TYPE VARCHAR2 (15)
ACTIVE VARCHAR2 (1)
CURRENCY VARCHAR2 (10)
DESCRIPTION VARCHAR2 (1000)
DUNS_NUMBER VARCHAR2 (30)
GL_ENTITIES VARCHAR2 (30)
PARENT_ID NUMBER

PARTNER_ID_X VARCHAR2 (30)
PARTNER_RATING VARCHAR2 (30)
PARTNER_ROLE VARCHAR2 (30)
PAYMENT_METHOD VARCHAR2 (30)
TAX_EXEMPT VARCHAR2 (1)
TAX_ID VARCHAR2 (30)
TERM_ID VARCHAR2 (30)
CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

SHIPPER_ACCOUNT_NUMBER VARCHAR2 (30)
TRANSACTION_ID NUMBER
Yes
Query Text

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


SELECT ID
,      NAME1
,      NAME2
,      NAME3
,      NAME4
,      NAME5
,      NAME6
,      NAME7
,      NAME8
,      NAME9
,      ONETIME
,      PARTNER_ID
,      PARTNER_TYPE
,      ACTIVE
,      CURRENCY
,      DESCRIPTION
,      DUNS_NUMBER
,      GL_ENTITIES
,      PARENT_ID
,      PARTNER_ID_X
,      PARTNER_RATING
,      PARTNER_ROLE
,      PAYMENT_METHOD
,      TAX_EXEMPT
,      TAX_ID
,      TERM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SHIPPER_ACCOUNT_NUMBER
,      TRANSACTION_ID
FROM FTE.FTE_MESSAGE_PARTNER#;

Dependencies

[top of page]

FTE.FTE_MESSAGE_PARTNER# references the following:

SchemaFTE
TableFTE_MESSAGE_PARTNER
FTE.FTE_MESSAGE_PARTNER# is referenced by following:

SchemaAPPS
SynonymFTE_MESSAGE_PARTNER