[Home] [Help] [Dependency Information]
Object Name: | CST_XLA_INV_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_XLA_INV_LINES_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) | ||
LINE_NUMBER | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | Yes | ||
ENTERED_AMOUNT | NUMBER | |||
ACCOUNTING_LINE_TYPE_CODE | NUMBER | Yes | ||
ACCOUNTED_AMOUNT | NUMBER | Yes | ||
RATE_OR_AMOUNT | NUMBER | |||
INV_TXN_BASIS_TYPE | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
MATERIAL_OVERHEAD_ID | NUMBER | |||
COST_ELEMENT_ID | NUMBER | |||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | ||
LOCATOR_ID | NUMBER | |||
TRANSFER_LOCATOR_ID | NUMBER | |||
COST_GROUP_ID | NUMBER | |||
TRANSFER_COST_GROUP_ID | NUMBER | |||
TO_PROJECT_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TO_TASK_ID | NUMBER | |||
TASK_ID | NUMBER | |||
LEDGER_ID | NUMBER | (15) | Yes | |
L_ORGANIZATION_ID | NUMBER | (15) | ||
DISTRIBUTION_IDENTIFIER | NUMBER | |||
TRANSACTION_ID | NUMBER | |||
L_ORGANIZATION_CODE | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, CODE_COMBINATION_ID
, ENTERED_AMOUNT
, ACCOUNTING_LINE_TYPE_CODE
, ACCOUNTED_AMOUNT
, RATE_OR_AMOUNT
, INV_TXN_BASIS_TYPE
, CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, MATERIAL_OVERHEAD_ID
, COST_ELEMENT_ID
, SUBINVENTORY_CODE
, TRANSFER_SUBINVENTORY
, LOCATOR_ID
, TRANSFER_LOCATOR_ID
, COST_GROUP_ID
, TRANSFER_COST_GROUP_ID
, TO_PROJECT_ID
, PROJECT_ID
, TO_TASK_ID
, TASK_ID
, LEDGER_ID
, L_ORGANIZATION_ID
, DISTRIBUTION_IDENTIFIER
, TRANSACTION_ID
, L_ORGANIZATION_CODE
FROM APPS.CST_XLA_INV_LINES_V;
|
|
|