eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: POA.EDW_TPRT_TPARTNER_LOC_LSTG

Object Details

Object Name:	EDW_TPRT_TPARTNER_LOC_LSTG
Object Type:	TABLE
Owner:	POA
FND Design Data:	BIS.EDW_TPRT_TPARTNER_LOC_LSTG POA.EDW_TPRT_TPARTNER_LOC_LSTG
Subobject Name:
Status:	VALID

This is the interface table for Trading Partner Location level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_TPRT_TPARTNER_LOC_LSTG_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TPARTNER_LOC_PK
EDW_TPRT_TPARTNER_LOC_LSTG_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COLLECTION_STATUS

Columns

Name	Datatype	Length	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
CUST_FOB_POINT	VARCHAR2	(40)	Customer Freight On Board point
CUST_ORDER_TYPE	VARCHAR2	(40)	Customer order type
CUST_PRICE_LIST	VARCHAR2	(40)	Customer price list
CUST_FREIGHT	VARCHAR2	(80)	Customer freight term
CUST_TERRITORY	VARCHAR2	(40)	Customer territory
CUST_TAX_REF	VARCHAR2	(80)	Customer tax reference number
CUST_SORT_PRTY	NUMBER		Customer site priority
CUST_TAX_CODE	VARCHAR2	(80)	Customer tax code for this site
CUST_DEMAND_CLASS	VARCHAR2	(80)	Customer demand class
CUST_TAX_CLASSFN	VARCHAR2	(80)	Customer tax classification of the bill-to site
CUST_TAX_HDR_FLAG	VARCHAR2	(20)	Indicates whether tax for customer should be calculated at the header level
CUST_TAX_ROUND	VARCHAR2	(40)	Customer tax rounding rule
CUST_SALES_REP	VARCHAR2	(120)	Customer sales representative name
INSTANCE	VARCHAR2	(40)	Source database instance for Trading Partner location
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute
LAST_UPDATE_DATE	DATE		Standard Who column
CREATION_DATE	DATE		Standard Who column
REQUEST_ID	NUMBER		Identifier used by collection program
OPERATION_CODE	VARCHAR2	(30)	Code used by the collection program to determine whether to insert/update/delete this record
ERROR_CODE	VARCHAR2	(2000)	Code used to store error messages
COLLECTION_STATUS	VARCHAR2	(30)	Loading status code for the record (It refers to the status after the Load Engine attempts to move the record from the staging table to the level table. It does not refer to the movement of the data from the source to the staging table)
TPARTNER_LOC_PK	VARCHAR2	(320)	Unique identifier
ROW_ID	VARCHAR2	(20)	Row identifier
TRADE_PARTNER_FK	VARCHAR2	(120)	Foreign key to the Trading Partner level
TRADE_PARTNER_FK_KEY	NUMBER		System generated foreign key to the Trading Partner level
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.
TPARTNER_LOC_DP	VARCHAR2	(480)	Unique Trading Partner Location name
NAME	VARCHAR2	(480)	Trading Partner Location name
DATE_FROM	DATE		Start date that trading partner location is valid
DATE_TO	DATE		End date that trading partner location is valid
VNDR_PURCH_SITE	VARCHAR2	(20)	Indicates that goods and services can be purchased from site
VNDR_RFQ_ONLY	VARCHAR2	(20)	Indicates that goods and services cannot be purchased from site. Only a Request for Quotation can be solicited.
VNDR_PAY_SITE	VARCHAR2	(20)	Indicates that trading partner location is a site where payments can be sent.
VNDR_PAY_TERMS	VARCHAR2	(80)	Agreed upon payment terms with trading partner location
CUST_SITE_USE	VARCHAR2	(40)	Customer site business purpose. For example: Bill To, Ship To, DUN.
CUST_LOCATION	VARCHAR2	(80)	Customer location
CUST_PRIMARY_FLAG	VARCHAR2	(20)	Indicates primary customer site
CUST_STATUS	VARCHAR2	(80)	Customer status: Active or Inactive
CUST_ORIG_SYS_REF	VARCHAR2	(320)	Customer record identifier from system origination source
CUST_SIC_CODE	VARCHAR2	(40)	Standard Industrial Classification code
CUST_PAY_TERMS	VARCHAR2	(80)	Payment terms agreed to with customer
CUST_GSA_IND	VARCHAR2	(20)	Indicates customer is Government Service Agency
CUST_SHIP_PARTIAL	VARCHAR2	(20)	Indicates whether partial shipment to customer is allowed
CUST_SHIP_VIA	VARCHAR2	(40)	Customer ship method
LEVEL_NAME	VARCHAR2	(15)	Level name

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
,      CUST_FOB_POINT
,      CUST_ORDER_TYPE
,      CUST_PRICE_LIST
,      CUST_FREIGHT
,      CUST_TERRITORY
,      CUST_TAX_REF
,      CUST_SORT_PRTY
,      CUST_TAX_CODE
,      CUST_DEMAND_CLASS
,      CUST_TAX_CLASSFN
,      CUST_TAX_HDR_FLAG
,      CUST_TAX_ROUND
,      CUST_SALES_REP
,      INSTANCE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      REQUEST_ID
,      OPERATION_CODE
,      ERROR_CODE
,      COLLECTION_STATUS
,      TPARTNER_LOC_PK
,      ROW_ID
,      TRADE_PARTNER_FK
,      TRADE_PARTNER_FK_KEY
,      BUSINESS_TYPE
,      TPARTNER_LOC_DP
,      NAME
,      DATE_FROM
,      DATE_TO
,      VNDR_PURCH_SITE
,      VNDR_RFQ_ONLY
,      VNDR_PAY_SITE
,      VNDR_PAY_TERMS
,      CUST_SITE_USE
,      CUST_LOCATION
,      CUST_PRIMARY_FLAG
,      CUST_STATUS
,      CUST_ORIG_SYS_REF
,      CUST_SIC_CODE
,      CUST_PAY_TERMS
,      CUST_GSA_IND
,      CUST_SHIP_PARTIAL
,      CUST_SHIP_VIA
,      LEVEL_NAME
FROM POA.EDW_TPRT_TPARTNER_LOC_LSTG;

Dependencies

[top of page]

POA.EDW_TPRT_TPARTNER_LOC_LSTG does not reference any database object

POA.EDW_TPRT_TPARTNER_LOC_LSTG is referenced by following:

APPS: EDW_TPRT_TPARTNER_LOC_LSTG