View: OP_CUST_MSTI2_VW1

Product:	GML - Process Manufacturing Logistics
Description:	Customer Master table view.
Implementation/DBA Data:	APPS.OP_CUST_MSTI2_VW1

View Text

SELECT "CUST_ID"
, "CUST_NO"
, "CUSTSORT_NO"
, "CUST_NAME"
, "PHONE_NO"
, "FAX_NO"
, "TELEX_NO"
, "ALTCUST_NO"
, "ADDR_ID"
, "MAILADDR_ID"
, "TERMS_CODE"
, "TERMS_VARY"
, "FOB_CODE"
, "SLSREP_CODE"
, "COMMISSION_CODE"
, "BACKORDER_IND"
, "STMT_IND"
, "SVCCHG_IND"
, "INACTIVE_IND"
, "BILL_IND"
, "SHIP_IND"
, "CUST_TYPE"
, "SIC_CODE"
, "FROM_WHSE"
, "TO_WHSE"
, "SPLC_CODE"
, "FRTBILL_MTHD"
, "CREDIT_LIMIT"
, "PRICECUST_ID"
, "CUST_TERRITORY"
, "CUST_CURRENCY"
, "CUST_CLASS"
, "CUSTTRADE_CLASS"
, "CUSTGL_CLASS"
, "TAXLOC_CODE"
, "TAXCALC_CODE"
, "DELETE_MARK"
, "TRANS_CNT"
, "TEXT_CODE"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "ATTRIBUTE16"
, "ATTRIBUTE17"
, "ATTRIBUTE18"
, "ATTRIBUTE19"
, "ATTRIBUTE20"
, "ATTRIBUTE21"
, "ATTRIBUTE22"
, "ATTRIBUTE23"
, "ATTRIBUTE24"
, "ATTRIBUTE25"
, "ATTRIBUTE26"
, "ATTRIBUTE27"
, "ATTRIBUTE28"
, "ATTRIBUTE29"
, "ATTRIBUTE30"
, "ATTRIBUTE_CATEGORY"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
FROM OP_CUST_MST
WHERE 1=1

Columns