FND Design Data [Home] [Help]

View: PO_VEND_MSTI2_VW1

Product: GML - Process Manufacturing Logistics
Description: View on vendor master table.
Implementation/DBA Data: ViewAPPS.PO_VEND_MSTI2_VW1
View Text

SELECT "CO_CODE"
, "VENDOR_ID"
, "VENDOR_NO"
, "ALTVEND_NO"
, "VENDSORT_NO"
, "VENDOR_NAME"
, "ADDR_ID"
, "REMIT_NAME"
, "MAILADDR_ID"
, "PHONE_NO"
, "FAX_NO"
, "TELEX_NO"
, "DEFAULT_CURRENCY"
, "CHANGE_CURRENCY"
, "TIMELINESS_RATING"
, "PRICE_RATING"
, "MISC_RATING"
, "BUS_START_DATE"
, "BUS_END_DATE"
, "BUS_AMOUNT"
, "MIN_PURCHASE"
, "APPROVED_IND"
, "INACTIVE_IND"
, "SHIP_IND"
, "PAYMENT_IND"
, "INFORM_GOVT"
, "TAXABLE_IND"
, "TERMS_CODE"
, "TERMS_VARY"
, "VENDOR_TYPE"
, "SIC_CODE"
, "SPLC_CODE"
, "FRTBILL_MTHD"
, "CREDIT_LIMIT"
, "VEND_CLASS"
, "VENDTRADE_CLASS"
, "VENDGL_CLASS"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "TRANS_CNT"
, "TEXT_CODE"
, "DELETE_MARK"
, "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"
FROM PO_VEND_MST

Columns

Name
CO_CODE
VENDOR_ID
VENDOR_NO
ALTVEND_NO
VENDSORT_NO
VENDOR_NAME
ADDR_ID
REMIT_NAME
MAILADDR_ID
PHONE_NO
FAX_NO
TELEX_NO
DEFAULT_CURRENCY
CHANGE_CURRENCY
TIMELINESS_RATING
PRICE_RATING
MISC_RATING
BUS_START_DATE
BUS_END_DATE
BUS_AMOUNT
MIN_PURCHASE
APPROVED_IND
INACTIVE_IND
SHIP_IND
PAYMENT_IND
INFORM_GOVT
TAXABLE_IND
TERMS_CODE
TERMS_VARY
VENDOR_TYPE
SIC_CODE
SPLC_CODE
FRTBILL_MTHD
CREDIT_LIMIT
VEND_CLASS
VENDTRADE_CLASS
VENDGL_CLASS
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
TRANS_CNT
TEXT_CODE
DELETE_MARK
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