CST_COSTED_INTR_ONHAND_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
COST_ORG_ID COST_BOOK_ID INVENTORY_ORG_ID INVENTORY_ITEM_ID SNAPSHOT_DATE EFF_TO_DATE QUANTITY UOM_CODE EXPENSE_TRANSACTION_FLAG |
問合せ
| SQL_Statement |
|---|
|
SELECT cast(NULL as NUMBER(18)) COST_ORG_ID, cast(NULL as NUMBER(18)) COST_BOOK_ID, cast(NULL as NUMBER(18)) INVENTORY_ORG_ID, cast(NULL as NUMBER(18)) INVENTORY_ITEM_ID, cast(NULL as DATE) SNAPSHOT_DATE, cast(NULL as DATE) EFF_TO_DATE, cast(NULL as NUMBER) QUANTITY, cast(NULL as VARCHAR2(3)) UOM_CODE, cast(NULL as VARCHAR2(1)) EXPENSE_TRANSACTION_FLAG FROM CST_B_COSTED_INTR_ONHAND_V WHERE 1=2 |