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_XLA_AWO_HEADERS_V

Object Details

Object Name:	CST_XLA_AWO_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_XLA_AWO_HEADERS_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
EVENT_ID	NUMBER	(15)
WRITE_OFF_ID	NUMBER		Yes
TRANSACTION_DATE	DATE		Yes
WO_TRANSACTION_TYPE_CODE	VARCHAR2	(25)	Yes
PO_DISTRIBUTION_ID	NUMBER
WO_OFFSET_ACCOUNT_ID	NUMBER
WO_ACCRUAL_ACCOUNT_ID	NUMBER		Yes
WO_ERV_ACCOUNT_ID	NUMBER
WO_COMMENTS	VARCHAR2	(240)
INVENTORY_ITEM_ID	NUMBER
VENDOR_ID	NUMBER
DESTINATION_TYPE_CODE	VARCHAR2	(25)
OPERATING_UNIT_ID	NUMBER		Yes
DISTRIBUTION_TYPE	CHAR	(14)
H_CURRENCY_CODE	VARCHAR2	(15)
H_CURRENCY_CONVERSION_DATE	DATE
H_CURRENCY_CONVERSION_RATE	NUMBER
H_CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
TRANSFER_TO_GL_INDICATOR	CHAR	(1)
H_ACCOUNTED_AMOUNT	NUMBER		Yes
H_ENTERED_AMOUNT	NUMBER
WO_ERV_AMOUNT	NUMBER
TOTAL_ACCRUAL_AMOUNT	NUMBER
FUNC_CURRENCY_CODE	VARCHAR2	(15)	Yes
FUNC_CURRENCY_CONVERSION_RATE	NUMBER
FUNC_CURRENCY_CONVERSION_TYPE	VARCHAR2	(0)
FUNC_CURRENCY_CONVERSION_DATE	DATE
H_LEDGER_ID	NUMBER	(15)	Yes
INVOICE_DISTRIBUTION_ID	NUMBER
INVENTORY_TRANSACTION_ID	NUMBER

Query Text

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


SELECT EVENT_ID
,      WRITE_OFF_ID
,      TRANSACTION_DATE
,      WO_TRANSACTION_TYPE_CODE
,      PO_DISTRIBUTION_ID
,      WO_OFFSET_ACCOUNT_ID
,      WO_ACCRUAL_ACCOUNT_ID
,      WO_ERV_ACCOUNT_ID
,      WO_COMMENTS
,      INVENTORY_ITEM_ID
,      VENDOR_ID
,      DESTINATION_TYPE_CODE
,      OPERATING_UNIT_ID
,      DISTRIBUTION_TYPE
,      H_CURRENCY_CODE
,      H_CURRENCY_CONVERSION_DATE
,      H_CURRENCY_CONVERSION_RATE
,      H_CURRENCY_CONVERSION_TYPE
,      TRANSFER_TO_GL_INDICATOR
,      H_ACCOUNTED_AMOUNT
,      H_ENTERED_AMOUNT
,      WO_ERV_AMOUNT
,      TOTAL_ACCRUAL_AMOUNT
,      FUNC_CURRENCY_CODE
,      FUNC_CURRENCY_CONVERSION_RATE
,      FUNC_CURRENCY_CONVERSION_TYPE
,      FUNC_CURRENCY_CONVERSION_DATE
,      H_LEDGER_ID
,      INVOICE_DISTRIBUTION_ID
,      INVENTORY_TRANSACTION_ID
FROM APPS.CST_XLA_AWO_HEADERS_V;

Dependencies

[top of page]

APPS.CST_XLA_AWO_HEADERS_V references the following:

APPS: CST_WRITE_OFFS; FND_CURRENCIES; GL_LEDGERS; XLA_EVENTS_GT

APPS.CST_XLA_AWO_HEADERS_V is referenced by following:

APPS: CST_XLA_AWO_LINES_V; XLA_00707_AAD_S_000002_PKG - show dependent code; XLA_00707_AAD_S_000005_PKG - show dependent code; XLA_00707_AAD_S_000007_PKG - show dependent code; XLA_00707_AAD_S_000019_PKG - show dependent code; XLA_00707_AAD_S_000020_PKG - show dependent code