[Home] [Help] [Dependency Information]
Object Name: | CST_PM_PENDING_TXN_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_PM_PENDING_TXN_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 |
---|---|---|---|---|
PROJECT_ID | NUMBER | The project identifier of the transaction | ||
TASK_ID | NUMBER | The task identifier of the transaction. | ||
ORGANIZATION_ID | NUMBER | The organization identifier of the transaction. | ||
TRANSACTION_ID | NUMBER | The transaction id of the transaction. | ||
PA_DATE | VARCHAR2 | (0) | The period date of Project Accounting based on the transaction date. | |
TRANSACTION_DATE | DATE | Transaction Date of the transaction | ||
ORIG_TRANSACTION_TABLE | NUMBER | It indicates the transaction table in use - 1 for mtl_material_transactions and 2 for wip_transactions. | ||
USER_REASON | VARCHAR2 | (4000) | A predefined reason which indicates why the corresponding transaction is not transferred to the PA interface.It can be either 'Error during cost collection' or 'Awaiting cost collection'. The seed data is in PA_EXCEPTION_REASONS. | |
USER_ACTION | VARCHAR2 | (4000) | A predefined recommended action. The seed data is in PA_EXCEPTION_REASONS. | |
EXCEPTION_CODE | VARCHAR2 | (5) | Exception code for the transaction |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, ORGANIZATION_ID
, TRANSACTION_ID
, PA_DATE
, TRANSACTION_DATE
, ORIG_TRANSACTION_TABLE
, USER_REASON
, USER_ACTION
, EXCEPTION_CODE
FROM APPS.CST_PM_PENDING_TXN_V;
APPS.CST_PM_PENDING_TXN_V is not referenced by any database object
|
|
|