View: EDW_TPRT_TRADE_PARTNER_LCV

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.EDW_TPRT_TRADE_PARTNER_LCV

View Text

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
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM EDWBV_TPRT_TRADE_PARTNER_LCV

Columns