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

TABLE: POA.EDW_TPRT_TPARTNER_LOC_LTC

Object Details
Object Name: EDW_TPRT_TPARTNER_LOC_LTC
Object Type: TABLE
Owner: POA
FND Design Data: TableBIS.EDW_TPRT_TPARTNER_LOC_LTC
TablePOA.EDW_TPRT_TPARTNER_LOC_LTC
Subobject Name:
Status: VALID


This is the Trading Partner Location level table in the Trading Partner dimension. This table contains information about the physical locations, or sites, of suppliers and customers.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_TPRT_TPARTNER_LOC_LTC_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnTPARTNER_LOC_PK_KEY
EDW_TPRT_TPARTNER_LOC_LTC_U2 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnTPARTNER_LOC_PK
ColumnTPARTNER_LOC_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ADDRESS_LINE1 VARCHAR2 (240)
First line of physical address
ADDRESS_LINE2 VARCHAR2 (240)
Second line of physical address
ADDRESS_LINE3 VARCHAR2 (240)
Third line of physical address
ADDRESS_LINE4 VARCHAR2 (240)
Fourth line of physical address
CITY VARCHAR2 (60)
City
COUNTY VARCHAR2 (240)
County
STATE VARCHAR2 (240)
State
POSTAL_CODE VARCHAR2 (60)
Postal Code
PROVINCE VARCHAR2 (240)
Province
COUNTRY VARCHAR2 (240)
Country
LEVEL_NAME VARCHAR2 (15)
Level name
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
INSTANCE VARCHAR2 (40)
Source database instance for Trading Partner Location
CUST_SALES_REP VARCHAR2 (120)
Customer sales representative name
CUST_TAX_ROUND VARCHAR2 (40)
Customer tax rounding rule
CUST_TAX_HDR_FLAG VARCHAR2 (20)
Indicates whether tax for customer should be calculated at the header level
CUST_TAX_CLASSFN VARCHAR2 (80)
Customer tax classification of the bill-to site
CUST_DEMAND_CLASS VARCHAR2 (80)
Customer demand class
CUST_TAX_CODE VARCHAR2 (80)
Customer tax code for this site
CUST_SORT_PRTY NUMBER

Customer site priority
CUST_TAX_REF VARCHAR2 (80)
Customer tax reference number
CUST_TERRITORY VARCHAR2 (40)
Customer territory
CUST_FREIGHT VARCHAR2 (80)
Customer freight term
CUST_PRICE_LIST VARCHAR2 (40)
Customer price list
CUST_ORDER_TYPE VARCHAR2 (40)
Customer order type
CUST_FOB_POINT VARCHAR2 (40)
Customer Freight On Board point
CUST_SHIP_VIA VARCHAR2 (40)
Customer ship method
CUST_SHIP_PARTIAL VARCHAR2 (20)
Indicates whether partial shipment to customer is allowed
CUST_GSA_IND VARCHAR2 (20)
Indicates customer is Government Service Agency
CUST_PAY_TERMS VARCHAR2 (80)
Payment terms agreed to with customer
CUST_SIC_CODE VARCHAR2 (40)
Customer Standard Industrial Classification code
CUST_ORIG_SYS_REF VARCHAR2 (320)
Customer record identifier from system origination source
CUST_STATUS VARCHAR2 (80)
Customer status: Active or Inactive
CUST_PRIMARY_FLAG VARCHAR2 (20)
Indicates primary customer site
CUST_LOCATION VARCHAR2 (80)
Customer location
CUST_SITE_USE VARCHAR2 (40)
Customer site business purpose. For example: Bill To, Ship To, DUN.
VNDR_PAY_TERMS VARCHAR2 (80)
Agreed upon payment terms with trading partner location
VNDR_PAY_SITE VARCHAR2 (20)
Indicates that trading partner location is a site where payments can be sent
VNDR_RFQ_ONLY VARCHAR2 (20)
Indicates that goods and services cannot be purchased from site. Only a Request for Quotation can be solicited.
VNDR_PURCH_SITE VARCHAR2 (20)
Indicates that goods and services can be purchased from site
DATE_TO DATE

End date that trading partner location is valid
DATE_FROM DATE

Start date that trading partner location is valid
NAME VARCHAR2 (480)
Trading Partner Location name
TPARTNER_LOC_DP VARCHAR2 (480)
Unique Trading Partner Location name
BUSINESS_TYPE VARCHAR2 (25)
Indicates whether trading partner is a vendor or a customer and which level they originates from. For Oracle Application source the values are: CUSTOMER, CUSTOMER ACOUNT, CUSTOMER SITE USE, PARTY, VENDOR, and VENDOR SITE.
TRADE_PARTNER_FK_KEY NUMBER

System generated foreign key to Trading Partner dimension
TRADE_PARTNER_FK VARCHAR2 (120)
Foreign key to Trading Partner dimension
TPARTNER_LOC_PK_KEY NUMBER

System generated unique identifier
TPARTNER_LOC_PK VARCHAR2 (320)
Unique identifier
Query Text

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


SELECT ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      COUNTY
,      STATE
,      POSTAL_CODE
,      PROVINCE
,      COUNTRY
,      LEVEL_NAME
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE1
,      INSTANCE
,      CUST_SALES_REP
,      CUST_TAX_ROUND
,      CUST_TAX_HDR_FLAG
,      CUST_TAX_CLASSFN
,      CUST_DEMAND_CLASS
,      CUST_TAX_CODE
,      CUST_SORT_PRTY
,      CUST_TAX_REF
,      CUST_TERRITORY
,      CUST_FREIGHT
,      CUST_PRICE_LIST
,      CUST_ORDER_TYPE
,      CUST_FOB_POINT
,      CUST_SHIP_VIA
,      CUST_SHIP_PARTIAL
,      CUST_GSA_IND
,      CUST_PAY_TERMS
,      CUST_SIC_CODE
,      CUST_ORIG_SYS_REF
,      CUST_STATUS
,      CUST_PRIMARY_FLAG
,      CUST_LOCATION
,      CUST_SITE_USE
,      VNDR_PAY_TERMS
,      VNDR_PAY_SITE
,      VNDR_RFQ_ONLY
,      VNDR_PURCH_SITE
,      DATE_TO
,      DATE_FROM
,      NAME
,      TPARTNER_LOC_DP
,      BUSINESS_TYPE
,      TRADE_PARTNER_FK_KEY
,      TRADE_PARTNER_FK
,      TPARTNER_LOC_PK_KEY
,      TPARTNER_LOC_PK
FROM POA.EDW_TPRT_TPARTNER_LOC_LTC;

Dependencies

[top of page]

POA.EDW_TPRT_TPARTNER_LOC_LTC does not reference any database object

POA.EDW_TPRT_TPARTNER_LOC_LTC is referenced by following:

SchemaAPPS
SynonymEDW_TPRT_TPARTNER_LOC_LTC