MSC_ANALYTIC_FACT_INV_REPL_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PLAN_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER INVENTORY_ITEM_ID ORGANIZATION_ID ITM_STOCK_OUTS SAFETY_STOCK_VIOLATIONS FILL_RATE_VIOLATIONS |
問合せ
| SQL_Statement |
|---|
|
select invReplFactVO.PLAN_ID ,invReplFactVO.CREATED_BY ,invReplFactVO.CREATION_DATE ,invReplFactVO.LAST_UPDATED_BY ,invReplFactVO.LAST_UPDATE_DATE ,invReplFactVO.LAST_UPDATE_LOGIN ,invReplFactVO.OBJECT_VERSION_NUMBER ,invReplFactVO.INVENTORY_ITEM_ID ,invReplFactVO.ORGANIZATION_ID ,invReplFactVO.ITM_STOCK_OUTS ,invReplFactVO.SAFETY_STOCK_VIOLATIONS ,invReplFactVO.FILL_RATE_VIOLATIONS from msc_analytic_private_plan_v planVO, msc_analytic_fact_inv_repl invReplFactVO where planVO.plan_id = invReplFactVO.plan_id |