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_P2_TPARTNER_LTC

Object Details

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

This is the Parent Trading Partner 2 level table in the Trading Partner dimension. This table contains data about trading partners who are the parent companies to other trading partners. Four parent trading partner levels are maintained.
Data for the second level (the fourth being the highest) parent trading partner is stored in this table. If there are not enough parent trading partners to occupy all of the parent trading partner levels , then the lowest level trading partner is pushed up to the appropriate level in the hierarchy, and occupies all the levels before it.
For example, is a supplier had only one parent supplier, then that supplier would be assigned to the Trading Partner, the Parent Trading Partner 1, the Parent Trading Partner 2, and the Parent Trading Partner 3 levels. The parent supplier would be assigned to the Parent Trading Partner 4 level.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_TPRT_P2_TPARTNER_LTC_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	TPARTNER_PK_KEY
EDW_TPRT_P2_TPARTNER_LTC_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	TPARTNER_PK TPARTNER_PK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
TPARTNER_PK_KEY	NUMBER			System generated unique identifier
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 Parent Trading Partner 2
ALLOW_UNORDER_RCV	VARCHAR2	(20)		Indicator that unordered receipts are allowed with supplier
ALLOW_SUB_RECEIPT	VARCHAR2	(20)		Indicator that receipts of substitute items are allowed with trading partner
RECEIPT_REQUIRED	VARCHAR2	(20)		Indicator that receipt is required for all shipments from trading partner before invoice is paid
INSPECT_REQUIRED	VARCHAR2	(20)		Indicator that inspection is required for all shipments from trading partner
HOLD_FLAG	VARCHAR2	(20)		Indicator that supplier is in hold status
SMALL_BUSINESS	VARCHAR2	(20)		Indicator that supplier is small business
WOMEN_OWNED	VARCHAR2	(20)		Indicator that supplier is woman-owned
MINORITY_GROUP	VARCHAR2	(80)		Minority group represented by supplier owners
ONE_TIME_FLAG	VARCHAR2	(20)		Indicator that supplier is for one time purchase
VENDOR_TYPE	VARCHAR2	(80)		Supplier type
VENDOR_NUMBER	VARCHAR2	(40)		Supplier number
PAYMENT_TERMS	VARCHAR2	(80)		Payment terms agreed to with trading partner
TAXPAYER_ID	VARCHAR2	(80)		Taxpayer Identification Number
TAX_REG_NUM	VARCHAR2	(80)		Tax registration number
SIC_CODE	VARCHAR2	(40)		Trading partner Standard Industrial Classification code
END_ACTIVE_DATE	DATE			End date for supplier validity
START_ACTIVE_DATE	DATE			Begin date for supplier validity
ALTERNATE_NAME	VARCHAR2	(320)		Parent Trading Partner 2 alternate name
NAME	VARCHAR2	(480)		Parent Trading Partner 2 name
TPARTNER_DP	VARCHAR2	(480)		Unique Parent Trading Partner 2 name
PARENT_TPARTNER_FK_KEY	NUMBER			System generated foreign key to the Parent Trading Partner 3 level
PARENT_TPARTNER_FK	VARCHAR2	(120)		Foreign key to the Parent Trading Partner 3 level
TPARTNER_PK	VARCHAR2	(120)		Unique identifier

Query Text

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


SELECT TPARTNER_PK_KEY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE1
,      INSTANCE
,      ALLOW_UNORDER_RCV
,      ALLOW_SUB_RECEIPT
,      RECEIPT_REQUIRED
,      INSPECT_REQUIRED
,      HOLD_FLAG
,      SMALL_BUSINESS
,      WOMEN_OWNED
,      MINORITY_GROUP
,      ONE_TIME_FLAG
,      VENDOR_TYPE
,      VENDOR_NUMBER
,      PAYMENT_TERMS
,      TAXPAYER_ID
,      TAX_REG_NUM
,      SIC_CODE
,      END_ACTIVE_DATE
,      START_ACTIVE_DATE
,      ALTERNATE_NAME
,      NAME
,      TPARTNER_DP
,      PARENT_TPARTNER_FK_KEY
,      PARENT_TPARTNER_FK
,      TPARTNER_PK
FROM POA.EDW_TPRT_P2_TPARTNER_LTC;

Dependencies

[top of page]

POA.EDW_TPRT_P2_TPARTNER_LTC does not reference any database object

POA.EDW_TPRT_P2_TPARTNER_LTC is referenced by following:

APPS: EDW_TPRT_P2_TPARTNER_LTC