[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_SUPP_TRD_PRFLS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | OZF |
| FND Design Data: |  OZF.OZF_SUPP_TRD_PRFLS_ALL
|
| Subobject Name: | |
| Status: | VALID |
OZF_SUPP_TRD_PRFLS_ALL stores the supplier trade profiles created from the Supplier trade profile UI.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OZF_SUPP_TRD_PRFLS_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SUPP_TRADE_PROFILE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SUPP_TRADE_PROFILE_ID | NUMBER | Yes | Primary key.It identifies a supplier trade profile for a supplier and supplier site. | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| REQUEST_ID | NUMBER | (15) | Standard WHO Column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard WHO Column | |
| CREATED_FROM | VARCHAR2 | (30) | Standard WHO Column | |
| PROGRAM_UPDATE_DATE | DATE | Standard WHO Column | ||
| PROGRAM_ID | NUMBER | (15) | Standard WHO Column | |
| ORG_ID | NUMBER | Yes | Operating unit id | |
| SUPPLIER_ID | NUMBER | Yes | Supplier id from ap_suppliers | |
| SUPPLIER_SITE_ID | NUMBER | Supplier Site id from ap_supplier_sites_all | ||
| PARTY_ID | NUMBER | Party id from hz_parties | ||
| CUST_ACCOUNT_ID | NUMBER | Customer Account id | ||
| CUST_ACCT_SITE_ID | NUMBER | Customer account site id | ||
| SITE_USE_ID | NUMBER | Bill to site id | ||
| PRE_APPROVAL_FLAG | VARCHAR2 | (1) | Pre-approval flag for Price protection | |
| APPROVAL_COMMUNICATION | VARCHAR2 | (30) | The default way to communicate approval in price protection | |
| GL_CONTRA_LIABILITY_ACCT | NUMBER | Default General Ledger accounts for Contra Liability (used for settling customer/ pass through price protection claims) | ||
| GL_COST_ADJUSTMENT_ACCT | NUMBER | Default Cost Adjustment account (used for Inventory cost updates) | ||
| DEFAULT_DAYS_COVERED | NUMBER | Defaulting value for days covered field on a price protection transaction | ||
| ALLOW_QTY_INCREASE | VARCHAR2 | (1) | Pre-approval flag for Ship and debit | |
| QTY_INCREASE_TOLERANCE | NUMBER | Tolerance is used to derive the maximum quantity on the underlying offer for a ship & debit request | ||
| AUTHORIZATION_PERIOD | NUMBER | Number of days for which a ship & debit authorization is typically approved by a Supplier | ||
| GRACE_DAYS | NUMBER | Grace Days captures number of days for which the ship & debit can be applied post the End Date on a ship & debit request | ||
| REQUEST_COMMUNICATION | VARCHAR2 | (30) | Ship and debit request communication method for a supplier | |
| CLAIM_COMMUNICATION | VARCHAR2 | (30) | Ship and debit claim communication method for a supplier | |
| CLAIM_FREQUENCY | NUMBER | Determines the frequency for the claim batch creation process for a supplier | ||
| CLAIM_FREQUENCY_UNIT | VARCHAR2 | (30) | Determines the frequency unit, like days, week, month for the claim batch creation process | |
| CLAIM_COMPUTATION_BASIS | NUMBER | Basis to determine the item cost value to be used for the ship and debit request creation | ||
| CLAIM_CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| DAYS_BEFORE_CLAIMING_DEBIT | NUMBER | This value is the number of days for which a distributor will wait to receive a response from the supplier, prior to automatically booking the debit (for the claimed amount) | ||
| MIN_CLAIM_AMT_LINE_LVL | NUMBER | Minimum Claim line amount | ||
| MIN_CLAIM_AMT | NUMBER | Minimum Claim amount | ||
| AUTO_DEBIT | VARCHAR2 | (1) | Auto debit to the supplier for a Ship and debit request | |
| LAST_PAID_DATE | DATE | Last date on which the claim has been paid | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Flexfield column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Flexfield column | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Flexfield column | |
| SECURITY_GROUP_ID | NUMBER | Standard WHO Column | ||
| DPP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Flexfield column | |
| DPP_ATTRIBUTE1 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE2 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE3 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE4 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE5 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE6 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE7 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE8 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE9 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE10 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE11 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE12 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE13 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE14 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE15 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE16 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE17 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE18 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE19 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE20 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE21 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE22 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE23 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE24 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE25 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE26 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE27 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE28 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE29 | VARCHAR2 | (150) | Flexfield column | |
| DPP_ATTRIBUTE30 | VARCHAR2 | (150) | Flexfield column | |
| CREATE_CLAIM_PRICE_INCREASE | VARCHAR2 | (1) | Flag to Create Claim for Price Protection Price Increase |
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
FROM OZF.OZF_SUPP_TRD_PRFLS_ALL;
OZF.OZF_SUPP_TRD_PRFLS_ALL does not reference any database object
OZF.OZF_SUPP_TRD_PRFLS_ALL is referenced by following:
APPS
OZF_SUPP_TRD_PRFLS
OZF_SUPP_TRD_PRFLS_ALL
|
|
|
|