[Home] [Help]
View: CST_PER_CLOSE_DTLS_V
Product: | BOM - Bills of Material |
Description: | This view consolidates the results of MTL_PER_CLOSE_DTLS and CST_PERIOD_CLOSE_SUMMARY |
Implementation/DBA Data: |
APPS.CST_PER_CLOSE_DTLS_V
|
View Text
SELECT ACCT_PERIOD_ID
, ORGANIZATION_ID
, COST_GROUP_ID
, SECONDARY_INVENTORY
, INVENTORY_ITEM_ID
, PERIOD_END_QUANTITY
, PERIOD_END_UNIT_COST FROM MTL_PER_CLOSE_DTLS UNION ALL SELECT ACCT_PERIOD_ID
, ORGANIZATION_ID
, COST_GROUP_ID
, SUBINVENTORY_CODE
, INVENTORY_ITEM_ID
, ROLLBACK_QUANTITY
, DECODE(ROLLBACK_QUANTITY
, 0
, 0
, ROLLBACK_VALUE/ROLLBACK_QUANTITY) FROM CST_PERIOD_CLOSE_SUMMARY
Columns
Name |
ACCT_PERIOD_ID |
ORGANIZATION_ID |
COST_GROUP_ID |
SECONDARY_INVENTORY |
INVENTORY_ITEM_ID |
PERIOD_END_QUANTITY |
PERIOD_END_UNIT_COST |