[Home] [Help] [Dependency Information]
Object Name: | OZF_SUPP_TRD_PRFLS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPP_TRADE_PROFILE_ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
CREATED_FROM | VARCHAR2 | (30) | ||
PROGRAM_UPDATE_DATE | DATE | |||
PROGRAM_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | Yes | ||
SUPPLIER_ID | NUMBER | Yes | ||
SUPPLIER_SITE_ID | NUMBER | |||
PARTY_ID | NUMBER | |||
CUST_ACCOUNT_ID | NUMBER | |||
CUST_ACCT_SITE_ID | NUMBER | |||
SITE_USE_ID | NUMBER | |||
PRE_APPROVAL_FLAG | VARCHAR2 | (1) | ||
APPROVAL_COMMUNICATION | VARCHAR2 | (30) | ||
GL_CONTRA_LIABILITY_ACCT | NUMBER | |||
GL_COST_ADJUSTMENT_ACCT | NUMBER | |||
DEFAULT_DAYS_COVERED | NUMBER | |||
ALLOW_QTY_INCREASE | VARCHAR2 | (1) | ||
QTY_INCREASE_TOLERANCE | NUMBER | |||
AUTHORIZATION_PERIOD | NUMBER | |||
GRACE_DAYS | NUMBER | |||
REQUEST_COMMUNICATION | VARCHAR2 | (30) | ||
CLAIM_COMMUNICATION | VARCHAR2 | (30) | ||
CLAIM_FREQUENCY | NUMBER | |||
CLAIM_FREQUENCY_UNIT | VARCHAR2 | (30) | ||
CLAIM_COMPUTATION_BASIS | NUMBER | |||
CLAIM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DAYS_BEFORE_CLAIMING_DEBIT | NUMBER | |||
MIN_CLAIM_AMT_LINE_LVL | NUMBER | |||
MIN_CLAIM_AMT | NUMBER | |||
AUTO_DEBIT | VARCHAR2 | (1) | ||
LAST_PAID_DATE | DATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (150) | ||
ATTRIBUTE17 | VARCHAR2 | (150) | ||
ATTRIBUTE18 | VARCHAR2 | (150) | ||
ATTRIBUTE19 | VARCHAR2 | (150) | ||
ATTRIBUTE20 | VARCHAR2 | (150) | ||
ATTRIBUTE21 | VARCHAR2 | (150) | ||
ATTRIBUTE22 | VARCHAR2 | (150) | ||
ATTRIBUTE23 | VARCHAR2 | (150) | ||
ATTRIBUTE24 | VARCHAR2 | (150) | ||
ATTRIBUTE25 | VARCHAR2 | (150) | ||
ATTRIBUTE26 | VARCHAR2 | (150) | ||
ATTRIBUTE27 | VARCHAR2 | (150) | ||
ATTRIBUTE28 | VARCHAR2 | (150) | ||
ATTRIBUTE29 | VARCHAR2 | (150) | ||
ATTRIBUTE30 | VARCHAR2 | (150) | ||
SECURITY_GROUP_ID | NUMBER | |||
DPP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
DPP_ATTRIBUTE1 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE2 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE3 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE4 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE5 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE6 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE7 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE8 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE9 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE10 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE11 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE12 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE13 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE14 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE15 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE16 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE17 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE18 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE19 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE20 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE21 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE22 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE23 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE24 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE25 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE26 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE27 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE28 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE29 | VARCHAR2 | (150) | ||
DPP_ATTRIBUTE30 | VARCHAR2 | (150) | ||
CREATE_CLAIM_PRICE_INCREASE | VARCHAR2 | (1) | ||
SKIP_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
SKIP_APPROVAL_FLAG | VARCHAR2 | (1) | ||
SETTLEMENT_METHOD_SUPPLIER_INC | VARCHAR2 | (30) | ||
SETTLEMENT_METHOD_SUPPLIER_DEC | VARCHAR2 | (30) | ||
SETTLEMENT_METHOD_CUSTOMER | VARCHAR2 | (30) | ||
SUPPLIER_NEG_BATCH_FLAG | VARCHAR2 | (5) | ||
SSD_IMD_CLAIM_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SUPP_TRADE_PROFILE_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, CREATED_FROM
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, ORG_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID
, SITE_USE_ID
, PRE_APPROVAL_FLAG
, APPROVAL_COMMUNICATION
, GL_CONTRA_LIABILITY_ACCT
, GL_COST_ADJUSTMENT_ACCT
, DEFAULT_DAYS_COVERED
, ALLOW_QTY_INCREASE
, QTY_INCREASE_TOLERANCE
, AUTHORIZATION_PERIOD
, GRACE_DAYS
, REQUEST_COMMUNICATION
, CLAIM_COMMUNICATION
, CLAIM_FREQUENCY
, CLAIM_FREQUENCY_UNIT
, CLAIM_COMPUTATION_BASIS
, CLAIM_CURRENCY_CODE
, DAYS_BEFORE_CLAIMING_DEBIT
, MIN_CLAIM_AMT_LINE_LVL
, MIN_CLAIM_AMT
, AUTO_DEBIT
, LAST_PAID_DATE
, ATTRIBUTE_CATEGORY
, 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
, SECURITY_GROUP_ID
, DPP_ATTRIBUTE_CATEGORY
, DPP_ATTRIBUTE1
, DPP_ATTRIBUTE2
, DPP_ATTRIBUTE3
, DPP_ATTRIBUTE4
, DPP_ATTRIBUTE5
, DPP_ATTRIBUTE6
, DPP_ATTRIBUTE7
, DPP_ATTRIBUTE8
, DPP_ATTRIBUTE9
, DPP_ATTRIBUTE10
, DPP_ATTRIBUTE11
, DPP_ATTRIBUTE12
, DPP_ATTRIBUTE13
, DPP_ATTRIBUTE14
, DPP_ATTRIBUTE15
, DPP_ATTRIBUTE16
, DPP_ATTRIBUTE17
, DPP_ATTRIBUTE18
, DPP_ATTRIBUTE19
, DPP_ATTRIBUTE20
, DPP_ATTRIBUTE21
, DPP_ATTRIBUTE22
, DPP_ATTRIBUTE23
, DPP_ATTRIBUTE24
, DPP_ATTRIBUTE25
, DPP_ATTRIBUTE26
, DPP_ATTRIBUTE27
, DPP_ATTRIBUTE28
, DPP_ATTRIBUTE29
, DPP_ATTRIBUTE30
, CREATE_CLAIM_PRICE_INCREASE
, SKIP_ADJUSTMENT_FLAG
, SKIP_APPROVAL_FLAG
, SETTLEMENT_METHOD_SUPPLIER_INC
, SETTLEMENT_METHOD_SUPPLIER_DEC
, SETTLEMENT_METHOD_CUSTOMER
, SUPPLIER_NEG_BATCH_FLAG
, SSD_IMD_CLAIM_FLAG
FROM OZF.OZF_SUPP_TRD_PRFLS_ALL#;
|
|
|