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]

VIEW: APPS.EDW_TPRT_TRADE_PARTNER_LCV

Object Details

Object Name:	EDW_TPRT_TRADE_PARTNER_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.EDW_TPRT_TRADE_PARTNER_LCV
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns

Name	Datatype	Length	Comments
TRADE_PARTNER_PK	VARCHAR2	(81)
PARENT_TPARTNER_FK	VARCHAR2	(80)
TRADE_PARTNER_DP	VARCHAR2	(240)
NAME	VARCHAR2	(240)
ALTERNATE_NAME	VARCHAR2	(320)
START_ACTIVE_DATE	DATE
END_ACTIVE_DATE	DATE
SIC_CODE	VARCHAR2	(30)
TAX_REG_NUM	VARCHAR2	(50)
TAXPAYER_ID	VARCHAR2	(20)
PAYMENT_TERMS	VARCHAR2	(50)
VNDR_NUMBER	VARCHAR2	(30)
VNDR_TYPE	VARCHAR2	(30)
VNDR_ONE_TIME	VARCHAR2	(1)
VNDR_MINORITY_GRP	VARCHAR2	(25)
VNDR_WOMEN_OWNED	VARCHAR2	(1)
VNDR_SMALL_BUS	VARCHAR2	(1)
VNDR_HOLD_FLAG	VARCHAR2	(1)
VNDR_INSPECT_REQ	VARCHAR2	(1)
VNDR_RECEIPT_REQ	VARCHAR2	(1)
VNDR_SUB_RECEIPT	VARCHAR2	(1)
VNDR_UNORDER_RCV	VARCHAR2	(1)
CUST_NUMBER	VARCHAR2	(30)
CUST_ORIG_SYS_REF	VARCHAR2	(240)
CUST_STATUS	VARCHAR2	(1)
CUST_TYPE	VARCHAR2	(30)
CUST_PROSPECT	VARCHAR2	(8)
CUST_CLASS	VARCHAR2	(30)
CUST_SALES_REP	VARCHAR2	(0)
CUST_SALES_CHNL	VARCHAR2	(30)
CUST_ORDER_TYPE	VARCHAR2	(30)
CUST_PRICE_LIST	VARCHAR2	(30)
CUST_ANALYSIS_FY	VARCHAR2	(5)
CUST_CAT_CODE	VARCHAR2	(0)
CUST_KEY	VARCHAR2	(80)
CUST_FISCAL_END	VARCHAR2	(30)
CUST_NUM_EMP	NUMBER
CUST_REVENUE_CURR	NUMBER
CUST_REVENUE_NEXT	NUMBER
CUST_REF_USE_FLAG	VARCHAR2	(0)
CUST_TAX_CODE	VARCHAR2	(60)
CUST_THIRD_PARTY	VARCHAR2	(0)
CUST_ACCESS_TMPL	VARCHAR2	(0)
CUST_COMPETITOR	VARCHAR2	(0)
CUST_ORIG_SYS	VARCHAR2	(0)
CUST_YEAR_EST	NUMBER
CUST_COTERM_DATE	VARCHAR2	(6)
CUST_FOB_POINT	VARCHAR2	(30)
CUST_FREIGHT	VARCHAR2	(30)
CUST_GSA_IND	VARCHAR2	(1)
CUST_SHIP_PARTIAL	VARCHAR2	(1)
CUST_SHIP_VIA	VARCHAR2	(30)
CUST_DO_NOT_MAIL	VARCHAR2	(1)
CUST_TAX_HDR_FLAG	VARCHAR2	(1)
CUST_TAX_ROUND	VARCHAR2	(30)
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
CREATION_DATE	DATE		Standard who column - date when this row was created.
OPERATION_CODE	VARCHAR2	(0)
VENDOR_ID	NUMBER
CUSTOMER_ID	NUMBER
INSTANCE	VARCHAR2	(30)
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)

Query Text

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


SELECT TRADE_PARTNER_PK
,      PARENT_TPARTNER_FK
,      TRADE_PARTNER_DP
,      NAME
,      ALTERNATE_NAME
,      START_ACTIVE_DATE
,      END_ACTIVE_DATE
,      SIC_CODE
,      TAX_REG_NUM
,      TAXPAYER_ID
,      PAYMENT_TERMS
,      VNDR_NUMBER
,      VNDR_TYPE
,      VNDR_ONE_TIME
,      VNDR_MINORITY_GRP
,      VNDR_WOMEN_OWNED
,      VNDR_SMALL_BUS
,      VNDR_HOLD_FLAG
,      VNDR_INSPECT_REQ
,      VNDR_RECEIPT_REQ
,      VNDR_SUB_RECEIPT
,      VNDR_UNORDER_RCV
,      CUST_NUMBER
,      CUST_ORIG_SYS_REF
,      CUST_STATUS
,      CUST_TYPE
,      CUST_PROSPECT
,      CUST_CLASS
,      CUST_SALES_REP
,      CUST_SALES_CHNL
,      CUST_ORDER_TYPE
,      CUST_PRICE_LIST
,      CUST_ANALYSIS_FY
,      CUST_CAT_CODE
,      CUST_KEY
,      CUST_FISCAL_END
,      CUST_NUM_EMP
,      CUST_REVENUE_CURR
,      CUST_REVENUE_NEXT
,      CUST_REF_USE_FLAG
,      CUST_TAX_CODE
,      CUST_THIRD_PARTY
,      CUST_ACCESS_TMPL
,      CUST_COMPETITOR
,      CUST_ORIG_SYS
,      CUST_YEAR_EST
,      CUST_COTERM_DATE
,      CUST_FOB_POINT
,      CUST_FREIGHT
,      CUST_GSA_IND
,      CUST_SHIP_PARTIAL
,      CUST_SHIP_VIA
,      CUST_DO_NOT_MAIL
,      CUST_TAX_HDR_FLAG
,      CUST_TAX_ROUND
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      OPERATION_CODE
,      VENDOR_ID
,      CUSTOMER_ID
,      INSTANCE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_TPRT_TRADE_PARTNER_LCV;

Dependencies

[top of page]

APPS.EDW_TPRT_TRADE_PARTNER_LCV references the following:

APPS: EDWBV_TPRT_TRADE_PARTNER_LCV

APPS.EDW_TPRT_TRADE_PARTNER_LCV is referenced by following:

APPS: EDW_TRD_PARTNER_M_C - show dependent code