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]

VIEW: APPS.DPP_XLA_INV_LINES_V

Object Details

Object Name:	DPP_XLA_INV_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	DPP.DPP_XLA_INV_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER	(15)		Event Id
LINE_NUMBER	NUMBER			Line Number
ENTERED_AMOUNT	NUMBER			Entered Amount
ACCOUNTED_AMOUNT	NUMBER			Accounted Amount
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
SUBINVENTORY_CODE	VARCHAR2	(10)		Transaction secondary inventory
LOCATOR_ID	NUMBER			Locator id for stock locators
COST_GROUP_ID	NUMBER			Cost group identifier
DISTRIBUTION_IDENTIFIER	NUMBER		Yes	Distribution Identifier
LEDGER_ID	NUMBER	(15)	Yes	Ledger Identifier
TRANSACTION_ID	NUMBER		Yes	Transaction Identifer
TRANSACTION_TYPE_ID	NUMBER		Yes	Transaction type identifier
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Yes	Transaction source type identifier
TRANSACTION_ACTION_ID	NUMBER		Yes	Transaction action identifier
PRIMARY_QUANTITY	NUMBER		Yes	Transaction quantity in terms of primary uom of the item
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
TRANSACTION_DATE	DATE		Yes	Transaction Date
COGS_CCID	NUMBER			Cost Of Goods Sold Code Combination Identifier
TRANSACTION_SUB_TYPE	VARCHAR2	(20)		Transaction Sub Type
ITEM_NUMBER	VARCHAR2	(40)		Item Number
LINE_ATTR_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
LINE_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield column.
LINE_ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield column.
SUPPLIER_PART_NUM	VARCHAR2	(240)		Supplier Part Number
PRIOR_PRICE	NUMBER		Yes	The price for which the product was purchased from supplier. This will be equal to list price for that item.
CHANGE_TYPE	VARCHAR2	(30)	Yes	Increase Amount, Increase Percentage, New Price, Decrease Amount, Decrease Percentage
CHANGE_VALUE	NUMBER		Yes	Change Value

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_ID
,      LINE_NUMBER
,      ENTERED_AMOUNT
,      ACCOUNTED_AMOUNT
,      CURRENCY_CODE
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      COST_GROUP_ID
,      DISTRIBUTION_IDENTIFIER
,      LEDGER_ID
,      TRANSACTION_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      PRIMARY_QUANTITY
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      COGS_CCID
,      TRANSACTION_SUB_TYPE
,      ITEM_NUMBER
,      LINE_ATTR_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      LINE_ATTRIBUTE16
,      LINE_ATTRIBUTE17
,      LINE_ATTRIBUTE18
,      LINE_ATTRIBUTE19
,      LINE_ATTRIBUTE20
,      LINE_ATTRIBUTE21
,      LINE_ATTRIBUTE22
,      LINE_ATTRIBUTE23
,      LINE_ATTRIBUTE24
,      LINE_ATTRIBUTE25
,      LINE_ATTRIBUTE26
,      LINE_ATTRIBUTE27
,      LINE_ATTRIBUTE28
,      LINE_ATTRIBUTE29
,      LINE_ATTRIBUTE30
,      SUPPLIER_PART_NUM
,      PRIOR_PRICE
,      CHANGE_TYPE
,      CHANGE_VALUE
FROM APPS.DPP_XLA_INV_LINES_V;

Dependencies

[top of page]

APPS.DPP_XLA_INV_LINES_V references the following:

APPS: DPP_TRANSACTION_HEADERS_ALL; DPP_TRANSACTION_LINES_ALL; DPP_XLA_EVENT_PUB - show dependent code; DPP_XLA_INV_HEADERS_V; DPP_XLA_LINES; GL_LEDGERS; HR_OPERATING_UNITS; MTL_MATERIAL_TRANSACTIONS; MTL_SYSTEM_ITEMS_B

APPS.DPP_XLA_INV_LINES_V is referenced by following:

APPS: XLA_09000_AAD_S_000015_PKG - show dependent code