VIEW: APPS.EDW_TPRT_TRADE_PARTNER_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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