eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OZF.OZF_SUPP_TRD_PRFLS_ALL

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_SUPP_TRD_PRFLS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUPP_TRADE_PROFILE_ID

Columns

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
SKIP_ADJUSTMENT_FLAG	VARCHAR2	(1)		Flag to Disable Adjustment for Price Protection
SKIP_APPROVAL_FLAG	VARCHAR2	(1)		Flag to Disable Approval for Price Protection
SETTLEMENT_METHOD_SUPPLIER_INC	VARCHAR2	(30)		Default Settlement Method for Price Protection Supplier Price Increase Claims
SETTLEMENT_METHOD_SUPPLIER_DEC	VARCHAR2	(30)		Default Settlement Method for Price Protection Supplier Price Decrease Claims
SETTLEMENT_METHOD_CUSTOMER	VARCHAR2	(30)		Default Settlement Method for Price Protection Customer Claims
SUPPLIER_NEG_BATCH_FLAG	VARCHAR2	(5)		Supplier Neg Batch Flag
SSD_IMD_CLAIM_FLAG	VARCHAR2	(1)		Flag for allowing immediate claims for Supplier Ship and Debit Batch

Query Text

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;

Dependencies

[top of page]

OZF.OZF_SUPP_TRD_PRFLS_ALL does not reference any database object

OZF.OZF_SUPP_TRD_PRFLS_ALL is referenced by following:

OZF: OZF_SUPP_TRD_PRFLS_ALL#