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.CST_INV_DISTRIBUTION_V

Object Details

Object Name:	CST_INV_DISTRIBUTION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_INV_DISTRIBUTION_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
TRANSACTION_ORGANIZATION_ID	NUMBER		Transaction Organization Idnetifier
TRANSACTION_ID	NUMBER		Transaction identifier
ORGANIZATION_ID	NUMBER		Organization identifier
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
DESCRIPTION	VARCHAR2	(240)	Description of the reason
REVISION	VARCHAR2	(3)	Revision Identifier
SUBINVENTORY_CODE	VARCHAR2	(10)	Subinventory Code
LOCATOR_ID	NUMBER		Locator Identifier
TRANSACTION_TYPE_ID	NUMBER		Transaction Type Identifier
TRANSACTION_TYPE_NAME	VARCHAR2	(80)	Transaction Type Name
TRANSACTION_SOURCE_TYPE_ID	NUMBER		Transaction Source Type Identifier
TRANSACTION_SOURCE_TYPE_NAME	VARCHAR2	(30)	Transaction Source Type Name
TRANSACTION_SOURCE_ID	NUMBER		Transaction Source Identifier
TRANSACTION_SOURCE_NAME	VARCHAR2	(80)	Transaction Source Name
TRANSACTION_DATE	DATE		Transaction date
TRANSACTION_QUANTITY	NUMBER		Transaction quantity
TRANSACTION_UOM	VARCHAR2	(3)	Transaction Unit of Measure
PRIMARY_QUANTITY	NUMBER		Transaction quantity in terms of primary UOM of item
PRIMARY_UOM	VARCHAR2	(3)	Primary Unit of Measure
OPERATION_SEQ_NUM	NUMBER		Operation sequence number within a routing
CURRENCY_CODE	VARCHAR2	(15)	Currency conversion code
CURRENCY_CONVERSION_DATE	DATE		Currency conversion date
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)	Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER		Currency conversion rate
DEPARTMENT_CODE	VARCHAR2	(10)	Transaction department code
REASON_NAME	VARCHAR2	(30)	Reason name
TRANSACTION_REFERENCE	VARCHAR2	(240)	Transaction reference code
REFERENCE_ACCOUNT	NUMBER		Transaction reference account (code_combination_id)
ACCOUNTING_LINE_TYPE	NUMBER		Accounting line type
LINE_TYPE_NAME	VARCHAR2	(80)	Accounting line type name
TRANSACTION_VALUE	NUMBER		Accounting value for the transaction
BASE_TRANSACTION_VALUE	NUMBER		Base Transaction Value
BASIS_TYPE_NAME	VARCHAR2	(80)	Base type name
COST_ELEMENT_ID	NUMBER		Cost Element Identifier
ACTIVITY	VARCHAR2	(10)	Activity name
RATE_OR_AMOUNT	NUMBER		Rate or Amount
GL_BATCH_ID	NUMBER		Batch identifier for all downloaded transaction journal entries (set to -1 if not yet transferred)
RESOURCE_CODE	VARCHAR2	(10)	Resource Code
UNIT_COST	VARCHAR2	(40)	Unit Cost
ROW_ID	ROWID	(10)	Row Identifier
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Who column
PROGRAM_ID	NUMBER		Concurrent Who column
PROGRAM_UPDATE_DATE	DATE		Concurrent Who column
MSI_INVENTORY_ITEM_ID	NUMBER		Item Identifier
MSI_ORGANIZATION_ID	NUMBER		Organization Identifier
MTA_TRANSACTION_DATE	DATE
PARENT_TRANSACTION_ID	NUMBER		Transaction ID of transaction flow parent
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
LOGICAL_TRX_TYPE	VARCHAR2	(80)	Logical Transaction Type Code

Query Text

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


SELECT TRANSACTION_ORGANIZATION_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      REVISION
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_TYPE_NAME
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_NAME
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      OPERATION_SEQ_NUM
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      DEPARTMENT_CODE
,      REASON_NAME
,      TRANSACTION_REFERENCE
,      REFERENCE_ACCOUNT
,      ACCOUNTING_LINE_TYPE
,      LINE_TYPE_NAME
,      TRANSACTION_VALUE
,      BASE_TRANSACTION_VALUE
,      BASIS_TYPE_NAME
,      COST_ELEMENT_ID
,      ACTIVITY
,      RATE_OR_AMOUNT
,      GL_BATCH_ID
,      RESOURCE_CODE
,      UNIT_COST
,      ROW_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      MSI_INVENTORY_ITEM_ID
,      MSI_ORGANIZATION_ID
,      MTA_TRANSACTION_DATE
,      PARENT_TRANSACTION_ID
,      ORGANIZATION_CODE
,      LOGICAL_TRX_TYPE
FROM APPS.CST_INV_DISTRIBUTION_V;

Dependencies

[top of page]

APPS.CST_INV_DISTRIBUTION_V references the following:

APPS: BOM_DEPARTMENTS; BOM_RESOURCES; CST_ACTIVITIES; GL_DAILY_CONVERSION_TYPES; MFG_LOOKUPS; MTL_MATERIAL_TRANSACTIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_VL; MTL_TRANSACTION_ACCOUNTS; MTL_TRANSACTION_REASONS; MTL_TRANSACTION_TYPES; MTL_TXN_SOURCE_TYPES

APPS.CST_INV_DISTRIBUTION_V is not referenced by any database object