[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PMIBV_ITEM_COST_FROM_GL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PMI.PMIBV_ITEM_COST_FROM_GL_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Costing info for an item. Costing info is retrieved from the GL equivalent of the item_cost view which retrieves data from OPM tables.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMPONENT_COST_AMT | NUMBER | Yes | Component Cost | |
| ITEMCOST_ID | NUMBER | (10) | Yes | Unique item cost identifier. Foreign key from GL_ITEM_CST table. |
| COST_CMPNTCLS_ID | NUMBER | (10) | Yes | Unique item cost component class identifier. |
| COST_ANALYSIS_CODE | VARCHAR2 | (4) | Yes | Cost analysis code of cost component. |
| ORGANIZATION_CODE | VARCHAR2 | (4) | Organization of item cost. | |
| WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse for the cost. ( Plant whse or default costing whse.) | |
| ITEM_ID | NUMBER | (10) | Item for which cost is stored | |
| COST_MTHD_CODE | VARCHAR2 | (4) | Cost method for accounting cost. | |
| CALENDAR_CODE | VARCHAR2 | (4) | Costing calendar code. | |
| PERIOD_CODE | VARCHAR2 | (4) | Costing period code. | |
| FORMULA_EFF_ID | NUMBER | (10) | Formula effectivity used in the calculation of accounting cost. | |
| GL_ITEMCOST_ID | NUMBER | (10) | Yes | Surrogate key to the row. Foreign Key to GL_ITEM_DTL table. |
| FINAL_FLAG | NUMBER | (5) | Yes | Indicates if Cost is frozen: 0 - not frozen, can be updated from CDA by running Cost Update process; 1 - Frozen, cannot be modified. |
| END_DATE | DATE | Yes | End effective date for the accounting cost. | |
| START_DATE | DATE | Yes | Start Effective date for accounting cost. | |
| COST_TYPE | NUMBER | (5) | Yes | Type of cost. 0=other; 1=std; 2=avg actual; 3=current. Not currently used. |
| ACCTG_COST | NUMBER | Yes | Item cost as seen by OPM programs, especially Susidiary Ledger Update process. | |
| CREATED_BY | VARCHAR2 | (16) | Yes | Standard who column |
| CREATION_DATE | VARCHAR2 | (40) | Yes | Standard who column |
| LAST_UPDATE_DATE | NUMBER | (10) | Yes | Standard who column |
| LAST_UPDATED_BY | NUMBER | (5) | Yes | Standard who column |
| COST_CMPNTCLS_CODE | NUMBER | (10) | Yes | Cost component class |
| COST_CMPNTCLS_DESC | NUMBER | (5) | Yes | Cost component class description |
| SORT_SEQUENCE | NUMBER | (5) | Yes | Sequence the component costs are sorted by on Cost details screen |
| USAGE_IND | VARCHAR2 | (8) | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment | |
| PRIMARY_CMPNTCLS_ID | NUMBER | (5) | Yes | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. |
| PRODUCT_COST_IND | NUMBER | (15) | Yes | This field indicates whether the component class will affect the cost of a product or not . Valid values are: 0 = Not a product cost, 1= Product Cost |
| UPDATE_COST_IND | DATE | Yes | This field indicates whether the component cost will be updated to the GL area. Valid values are 0= Do not update to GL Area, 1=Update to GL Area. | |
| CMPNT_GROUP | DATE | Yes | Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group | |
| PPV_IND | NUMBER | (15) | Yes | Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations. |
Cut, paste (and edit) the following text to query this object:
SELECT COMPONENT_COST_AMT
, ITEMCOST_ID
, COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE
, ORGANIZATION_CODE
, WAREHOUSE_CODE
, ITEM_ID
, COST_MTHD_CODE
, CALENDAR_CODE
, PERIOD_CODE
, FORMULA_EFF_ID
, GL_ITEMCOST_ID
, FINAL_FLAG
, END_DATE
, START_DATE
, COST_TYPE
, ACCTG_COST
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, COST_CMPNTCLS_CODE
, COST_CMPNTCLS_DESC
, SORT_SEQUENCE
, USAGE_IND
, PRIMARY_CMPNTCLS_ID
, PRODUCT_COST_IND
, UPDATE_COST_IND
, CMPNT_GROUP
, PPV_IND
FROM APPS.PMIBV_ITEM_COST_FROM_GL_V;
APPS
CM_CMPT_MST
GL_ITEM_CST
GL_ITEM_DTL
APPS.PMIBV_ITEM_COST_FROM_GL_V is not referenced by any database object
|
|
|
|