[Home] [Help] [Dependency Information]
Object Name: | JAI_OPM_CM_ADJS_DTL |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_OPM_CM_ADJS_DTL |
Subobject Name: | |
Status: | VALID |
This table stores the cost adjustment details as part of OPM Costing
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CM_ADJS_DTL_ID | NUMBER | (15) | Yes | OPM Adjustment Detail Identifier |
ITEM_ID | NUMBER | Yes | Item Identifier | |
WHSE_CODE | VARCHAR2 | (4) | Yes | Holds the Warehouse Code |
CALENDAR_CODE | VARCHAR2 | (4) | Holds the Calendar Code defined for the transaction based on dates | |
PERIOD_CODE | VARCHAR2 | (4) | Yes | Holds the Period Code defined for the transaction based on dates |
COST_MTHD_CODE | VARCHAR2 | (4) | Yes | Hold the actual cost method code |
COST_CMPNTCLS_ID | NUMBER | (15) | Yes | Component Class Identifier |
COST_ANALYSIS_CODE | VARCHAR2 | (4) | Yes | Holds the Cost Analysis Code |
COST_ADJUST_ID | NUMBER | (15) | Yes | Cost Adjustment Identifier |
ADJUST_COST | NUMBER | Yes | Adjustment cost per uom | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Invoice Distribution Identifier | |
INVOICE_ID | NUMBER | (15) | Yes | Invoice Identifier |
RCV_TRANSACTION_ID | NUMBER | (15) | Yes | Receiving Transaction Identifier |
DELETE_MARK | NUMBER | Possible values are 0 and 1 | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Holds the Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT CM_ADJS_DTL_ID
, ITEM_ID
, WHSE_CODE
, CALENDAR_CODE
, PERIOD_CODE
, COST_MTHD_CODE
, COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE
, COST_ADJUST_ID
, ADJUST_COST
, CREATION_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, INVOICE_DISTRIBUTION_ID
, INVOICE_ID
, RCV_TRANSACTION_ID
, DELETE_MARK
, OBJECT_VERSION_NUMBER
FROM JA.JAI_OPM_CM_ADJS_DTL;
JA.JAI_OPM_CM_ADJS_DTL does not reference any database object
JA.JAI_OPM_CM_ADJS_DTL is referenced by following:
|
|
|