[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
|
|
|