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_DISTRIBUTION_VIEW

Object Details

Object Name:	CST_DISTRIBUTION_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_DISTRIBUTION_VIEW
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	Comments
WIP_ENTITY_ID	NUMBER		WIP job or repetitive assembly identifier
LINE_ID	NUMBER		WIP repetitive line identifier
ACCT_PERIOD_ID	NUMBER		Accounting period identifier
ORGANIZATION_ID	NUMBER		Organization identifier
REFERENCE_ACCOUNT	NUMBER		Transaction distribution account
TRANSACTION_DATE	DATE		Date transaction was performed
OPERATION_SEQ_NUM	NUMBER		Operation sequence number within a routing
TRANSACTION_TYPE_ID	NUMBER		Transaction type code
ITEM_OR_RESOURCE_ID	NUMBER		Inventory item identifier or resource identifier
PRIMARY_QUANTITY	NUMBER		Transaction quantity in the primary unit of measure
EXTENDED_COST	NUMBER		Total cost of the transaction
PRIMARY_UOM	VARCHAR2	(3)	Primary unit of measure
UNIT_COST	NUMBER		Total unit cost
BASIS	VARCHAR2	(80)	Basis name for charging resource
RESOURCE_SEQ_NUM	NUMBER		Resource sequence number
TRANSACTION_ID	NUMBER		Transaction identifier
COST_ELEMENT_ID	NUMBER		Cost element identifier

Query Text

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


SELECT WIP_ENTITY_ID
,      LINE_ID
,      ACCT_PERIOD_ID
,      ORGANIZATION_ID
,      REFERENCE_ACCOUNT
,      TRANSACTION_DATE
,      OPERATION_SEQ_NUM
,      TRANSACTION_TYPE_ID
,      ITEM_OR_RESOURCE_ID
,      PRIMARY_QUANTITY
,      EXTENDED_COST
,      PRIMARY_UOM
,      UNIT_COST
,      BASIS
,      RESOURCE_SEQ_NUM
,      TRANSACTION_ID
,      COST_ELEMENT_ID
FROM APPS.CST_DISTRIBUTION_VIEW;

Dependencies

[top of page]

APPS.CST_DISTRIBUTION_VIEW references the following:

APPS: MFG_LOOKUPS; MTL_MATERIAL_TRANSACTIONS; MTL_SYSTEM_ITEMS_B; MTL_TRANSACTION_ACCOUNTS; WIP_TRANSACTIONS; WIP_TRANSACTION_ACCOUNTS

APPS.CST_DISTRIBUTION_VIEW is not referenced by any database object