FND Design Data [Home] [Help]

View: EDW_TPRT_TPARTNER_LOC_LCV

Product: PO - Purchasing
Description:
Implementation/DBA Data: ViewAPPS.EDW_TPRT_TPARTNER_LOC_LCV
View Text

SELECT TPARTNER_LOC_PK
, TRADE_PARTNER_FK
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ADDRESS_LINE4
, CITY
, COUNTY
, STATE
, POSTAL_CODE
, PROVINCE
, COUNTRY
, 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
, 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
, TPARTNER_LOC_ID
, LAST_UPDATE_DATE
, CREATION_DATE
, OPERATION_CODE
, LEVEL_NAME
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM EDWBV_TPRT_TPARTNER_LOC_LCV

Columns

Name
TPARTNER_LOC_PK
TRADE_PARTNER_FK
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_LINE4
CITY
COUNTY
STATE
POSTAL_CODE
PROVINCE
COUNTRY
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
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
TPARTNER_LOC_ID
LAST_UPDATE_DATE
CREATION_DATE
OPERATION_CODE
LEVEL_NAME
USER_ATTRIBUTE1
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5