CST_B_STD_COSTS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
STD_COST_ID SCENARIO_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE VAL_STRUCTURE_ID COST_PROFILE_ID INVENTORY_ORG_ID ASSIGNMENT_LEVEL STATUS_CODE TOTAL_COST CURRENCY_CODE UOM_CODE PREVIOUS_STD_COST_ID PREVIOUS_EFFECTIVE_START_DATE PREVIOUS_EFFECTIVE_END_DATE PREVIOUS_TOTAL_COST STD_COST_ADJUST_ID STAGED_FOR_STD_COST_ADJ_FLAG EXTERNAL_SYSTEM_REFERENCE EXTERNAL_SYSTEM_REF_ID INV_VAL_USE_FLAG LAST_USED_DATE SCENARIO_EVENT_ID SCENARIO_ROLLUP_HEADER_ID ORGANIZATION_ID VAL_STRUCTURE_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID

Name

STD_COST_ID

SCENARIO_ID

COST_ORG_ID

COST_BOOK_ID

INVENTORY_ITEM_ID

VAL_UNIT_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

VAL_STRUCTURE_ID

COST_PROFILE_ID

INVENTORY_ORG_ID

ASSIGNMENT_LEVEL

STATUS_CODE

TOTAL_COST

CURRENCY_CODE

UOM_CODE

PREVIOUS_STD_COST_ID

PREVIOUS_EFFECTIVE_START_DATE

PREVIOUS_EFFECTIVE_END_DATE

PREVIOUS_TOTAL_COST

STD_COST_ADJUST_ID

STAGED_FOR_STD_COST_ADJ_FLAG

EXTERNAL_SYSTEM_REFERENCE

EXTERNAL_SYSTEM_REF_ID

INV_VAL_USE_FLAG

LAST_USED_DATE

SCENARIO_EVENT_ID

SCENARIO_ROLLUP_HEADER_ID

ORGANIZATION_ID

VAL_STRUCTURE_TYPE_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

Query

SQL_Statement
SELECT CSC.STD_COST_ID, CSC.SCENARIO_ID, CSC.COST_ORG_ID, CSC.COST_BOOK_ID, CSC.INVENTORY_ITEM_ID, CSC.VAL_UNIT_ID, CSC.EFFECTIVE_START_DATE, CSC.EFFECTIVE_END_DATE, CSC.VAL_STRUCTURE_ID, CSC.COST_PROFILE_ID, CSC.INVENTORY_ORG_ID, CSC.ASSIGNMENT_LEVEL, CSC.STATUS_CODE, CSC.TOTAL_COST, CSC.CURRENCY_CODE, CSC.UOM_CODE, CSC.PREVIOUS_STD_COST_ID, CSC.PREVIOUS_EFFECTIVE_START_DATE, CSC.PREVIOUS_EFFECTIVE_END_DATE, CSC.PREVIOUS_TOTAL_COST, CSC.STD_COST_ADJUST_ID, CSC.STAGED_FOR_STD_COST_ADJ_FLAG, CSC.EXTERNAL_SYSTEM_REFERENCE, CSC.EXTERNAL_SYSTEM_REF_ID, CSC.INV_VAL_USE_FLAG, CSC.LAST_USED_DATE, CSC.SCENARIO_EVENT_ID, CSC.SCENARIO_ROLLUP_HEADER_ID, CSC.ORGANIZATION_ID, VS.VAL_STRUCTURE_TYPE_CODE, CSC.CREATED_BY, CSC.CREATION_DATE, CSC.LAST_UPDATED_BY, CSC.LAST_UPDATE_DATE, CSC.LAST_UPDATE_LOGIN, CSC.REQUEST_ID FROM CST_STD_COSTS CSC, CST_VAL_STRUCTURES_B VS WHERE VS.VAL_STRUCTURE_ID = CSC.VAL_STRUCTURE_ID AND VS.VAL_STRUCTURE_TYPE_CODE = 'ASSET' UNION ALL SELECT DISTINCT CSC.STD_COST_ID, CSC.SCENARIO_ID, CSC.COST_ORG_ID, CSC.COST_BOOK_ID, CSC.INVENTORY_ITEM_ID, EVU.VAL_UNIT_ID, CSC.EFFECTIVE_START_DATE, CSC.EFFECTIVE_END_DATE, ECP.VAL_STRUCTURE_ID, ECP.COST_PROFILE_ID, CSC.INVENTORY_ORG_ID, CSC.ASSIGNMENT_LEVEL, CSC.STATUS_CODE, CSC.TOTAL_COST, CSC.CURRENCY_CODE, CSC.UOM_CODE, CSC.PREVIOUS_STD_COST_ID, CSC.PREVIOUS_EFFECTIVE_START_DATE, CSC.PREVIOUS_EFFECTIVE_END_DATE, CSC.PREVIOUS_TOTAL_COST, CSC.STD_COST_ADJUST_ID, CSC.STAGED_FOR_STD_COST_ADJ_FLAG, CSC.EXTERNAL_SYSTEM_REFERENCE, CSC.EXTERNAL_SYSTEM_REF_ID, CSC.INV_VAL_USE_FLAG, CSC.LAST_USED_DATE, CSC.SCENARIO_EVENT_ID, CSC.SCENARIO_ROLLUP_HEADER_ID, CSC.ORGANIZATION_ID, VS.VAL_STRUCTURE_TYPE_CODE, CSC.CREATED_BY, CSC.CREATION_DATE, CSC.LAST_UPDATED_BY, CSC.LAST_UPDATE_DATE, CSC.LAST_UPDATE_LOGIN, CSC.REQUEST_ID FROM CST_STD_COSTS CSC, CST_ITEM_COST_PROFILES ICP, CST_COST_PROFILES_B ACP, CST_COST_PROFILES_B ECP, CST_VAL_UNITS_B AVU, CST_VAL_UNITS_B EVU, CST_VAL_UNIT_DETAILS AVUD, CST_VAL_UNIT_DETAILS EVUD, CST_VAL_UNIT_COMBINATIONS AVUC, CST_VAL_UNIT_COMBINATIONS EVUC, CST_VAL_STRUCTURES_B VS WHERE ICP.COST_ORG_ID = CSC.COST_ORG_ID AND ICP.COST_BOOK_ID = CSC.COST_BOOK_ID AND ICP.INVENTORY_ITEM_ID = CSC.INVENTORY_ITEM_ID AND ICP.ASSET_COST_PROFILE_ID = ACP.COST_PROFILE_ID AND ICP.EXPENSE_COST_PROFILE_ID = ECP.COST_PROFILE_ID AND AVU.COST_ORG_ID = ICP.COST_ORG_ID AND AVU.COST_BOOK_ID = ICP.COST_BOOK_ID AND AVU.VAL_STRUCTURE_ID = ACP.VAL_STRUCTURE_ID AND EVU.COST_ORG_ID = ICP.COST_ORG_ID AND EVU.COST_BOOK_ID = ICP.COST_BOOK_ID AND EVU.VAL_STRUCTURE_ID = ECP.VAL_STRUCTURE_ID AND AVUD.VAL_UNIT_ID = AVU.VAL_UNIT_ID AND EVUD.VAL_UNIT_ID = EVU.VAL_UNIT_ID AND AVUD.VAL_UNIT_COMBINATION_ID = AVUC.VAL_UNIT_COMBINATION_ID AND EVUD.VAL_UNIT_COMBINATION_ID = EVUC.VAL_UNIT_COMBINATION_ID AND AVU.COST_ORG_ID = CSC.COST_ORG_ID AND AVU.COST_BOOK_ID = CSC.COST_BOOK_ID AND AVUC.COST_ORG_CODE = EVUC.COST_ORG_CODE AND NVL(AVUC.INV_ORG_CODE, ' ') = NVL(EVUC.INV_ORG_CODE, ' ') AND NVL(AVUC.SUBINVENTORY_CODE, ' ') = NVL(EVUC.SUBINVENTORY_CODE, ' ') AND NVL(AVUC.LOT_NUMBER, ' ') = NVL(EVUC.LOT_NUMBER, ' ') AND NVL(AVUC.GRADE_CODE, ' ') = NVL(EVUC.GRADE_CODE, ' ') AND NVL(AVUC.SERIAL_NUMBER, ' ') = NVL(EVUC.SERIAL_NUMBER, ' ') AND NVL(AVUC.LOCATOR_ID, 0) = NVL(EVUC.LOCATOR_ID, 0) AND VS.VAL_STRUCTURE_ID = EVU.VAL_STRUCTURE_ID AND VS.VAL_STRUCTURE_TYPE_CODE = 'EXPENSE' AND AVU.VAL_UNIT_ID = CSC.VAL_UNIT_ID

SQL_Statement

SELECT CSC.STD_COST_ID,

CSC.SCENARIO_ID,

CSC.COST_ORG_ID,

CSC.COST_BOOK_ID,

CSC.INVENTORY_ITEM_ID,

CSC.VAL_UNIT_ID,

CSC.EFFECTIVE_START_DATE,

CSC.EFFECTIVE_END_DATE,

CSC.VAL_STRUCTURE_ID,

CSC.COST_PROFILE_ID,

CSC.INVENTORY_ORG_ID,

CSC.ASSIGNMENT_LEVEL,

CSC.STATUS_CODE,

CSC.TOTAL_COST,

CSC.CURRENCY_CODE,

CSC.UOM_CODE,

CSC.PREVIOUS_STD_COST_ID,

CSC.PREVIOUS_EFFECTIVE_START_DATE,

CSC.PREVIOUS_EFFECTIVE_END_DATE,

CSC.PREVIOUS_TOTAL_COST,

CSC.STD_COST_ADJUST_ID,

CSC.STAGED_FOR_STD_COST_ADJ_FLAG,

CSC.EXTERNAL_SYSTEM_REFERENCE,

CSC.EXTERNAL_SYSTEM_REF_ID,

CSC.INV_VAL_USE_FLAG,

CSC.LAST_USED_DATE,

CSC.SCENARIO_EVENT_ID,

CSC.SCENARIO_ROLLUP_HEADER_ID,

CSC.ORGANIZATION_ID,

VS.VAL_STRUCTURE_TYPE_CODE,

CSC.CREATED_BY,

CSC.CREATION_DATE,

CSC.LAST_UPDATED_BY,

CSC.LAST_UPDATE_DATE,

CSC.LAST_UPDATE_LOGIN,

CSC.REQUEST_ID

FROM CST_STD_COSTS CSC,

CST_VAL_STRUCTURES_B VS

WHERE VS.VAL_STRUCTURE_ID = CSC.VAL_STRUCTURE_ID

AND VS.VAL_STRUCTURE_TYPE_CODE = 'ASSET'

UNION ALL

SELECT DISTINCT CSC.STD_COST_ID,

CSC.SCENARIO_ID,

CSC.COST_ORG_ID,

CSC.COST_BOOK_ID,

CSC.INVENTORY_ITEM_ID,

EVU.VAL_UNIT_ID,

CSC.EFFECTIVE_START_DATE,

CSC.EFFECTIVE_END_DATE,

ECP.VAL_STRUCTURE_ID,

ECP.COST_PROFILE_ID,

CSC.INVENTORY_ORG_ID,

CSC.ASSIGNMENT_LEVEL,

CSC.STATUS_CODE,

CSC.TOTAL_COST,

CSC.CURRENCY_CODE,

CSC.UOM_CODE,

CSC.PREVIOUS_STD_COST_ID,

CSC.PREVIOUS_EFFECTIVE_START_DATE,

CSC.PREVIOUS_EFFECTIVE_END_DATE,

CSC.PREVIOUS_TOTAL_COST,

CSC.STD_COST_ADJUST_ID,

CSC.STAGED_FOR_STD_COST_ADJ_FLAG,

CSC.EXTERNAL_SYSTEM_REFERENCE,

CSC.EXTERNAL_SYSTEM_REF_ID,

CSC.INV_VAL_USE_FLAG,

CSC.LAST_USED_DATE,

CSC.SCENARIO_EVENT_ID,

CSC.SCENARIO_ROLLUP_HEADER_ID,

CSC.ORGANIZATION_ID,

VS.VAL_STRUCTURE_TYPE_CODE,

CSC.CREATED_BY,

CSC.CREATION_DATE,

CSC.LAST_UPDATED_BY,

CSC.LAST_UPDATE_DATE,

CSC.LAST_UPDATE_LOGIN,

CSC.REQUEST_ID

FROM CST_STD_COSTS CSC,

CST_ITEM_COST_PROFILES ICP,

CST_COST_PROFILES_B ACP,

CST_COST_PROFILES_B ECP,

CST_VAL_UNITS_B AVU,

CST_VAL_UNITS_B EVU,

CST_VAL_UNIT_DETAILS AVUD,

CST_VAL_UNIT_DETAILS EVUD,

CST_VAL_UNIT_COMBINATIONS AVUC,

CST_VAL_UNIT_COMBINATIONS EVUC,

CST_VAL_STRUCTURES_B VS

WHERE ICP.COST_ORG_ID = CSC.COST_ORG_ID

AND ICP.COST_BOOK_ID = CSC.COST_BOOK_ID

AND ICP.INVENTORY_ITEM_ID = CSC.INVENTORY_ITEM_ID

AND ICP.ASSET_COST_PROFILE_ID = ACP.COST_PROFILE_ID

AND ICP.EXPENSE_COST_PROFILE_ID = ECP.COST_PROFILE_ID

AND AVU.COST_ORG_ID = ICP.COST_ORG_ID

AND AVU.COST_BOOK_ID = ICP.COST_BOOK_ID

AND AVU.VAL_STRUCTURE_ID = ACP.VAL_STRUCTURE_ID

AND EVU.COST_ORG_ID = ICP.COST_ORG_ID

AND EVU.COST_BOOK_ID = ICP.COST_BOOK_ID

AND EVU.VAL_STRUCTURE_ID = ECP.VAL_STRUCTURE_ID

AND AVUD.VAL_UNIT_ID = AVU.VAL_UNIT_ID

AND EVUD.VAL_UNIT_ID = EVU.VAL_UNIT_ID

AND AVUD.VAL_UNIT_COMBINATION_ID = AVUC.VAL_UNIT_COMBINATION_ID

AND EVUD.VAL_UNIT_COMBINATION_ID = EVUC.VAL_UNIT_COMBINATION_ID

AND AVU.COST_ORG_ID = CSC.COST_ORG_ID

AND AVU.COST_BOOK_ID = CSC.COST_BOOK_ID

AND AVUC.COST_ORG_CODE = EVUC.COST_ORG_CODE

AND NVL(AVUC.INV_ORG_CODE, ' ') = NVL(EVUC.INV_ORG_CODE, ' ')

AND NVL(AVUC.SUBINVENTORY_CODE, ' ') = NVL(EVUC.SUBINVENTORY_CODE, ' ')

AND NVL(AVUC.LOT_NUMBER, ' ') = NVL(EVUC.LOT_NUMBER, ' ')

AND NVL(AVUC.GRADE_CODE, ' ') = NVL(EVUC.GRADE_CODE, ' ')

AND NVL(AVUC.SERIAL_NUMBER, ' ') = NVL(EVUC.SERIAL_NUMBER, ' ')

AND NVL(AVUC.LOCATOR_ID, 0) = NVL(EVUC.LOCATOR_ID, 0)

AND VS.VAL_STRUCTURE_ID = EVU.VAL_STRUCTURE_ID

AND VS.VAL_STRUCTURE_TYPE_CODE = 'EXPENSE'

AND AVU.VAL_UNIT_ID = CSC.VAL_UNIT_ID