VIEW: APPS.EDW_TPRT_TPARTNER_LOC_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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