OKC_STI_ASSET_TXN_DETAILS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: OKC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID TAL_ID ASSET_ID ASSET_QUANTITY OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT A.ID ID , A.TAL_ID TAL_ID, A.ASSET_ID ASSET_ID , A.ASSET_QUANTITY ASSET_QUANTITY , A.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , A.CREATED_BY CREATED_BY , A.CREATION_DATE CREATION_DATE , A.LAST_UPDATED_BY LAST_UPDATED_BY , A.LAST_UPDATE_DATE LAST_UPDATE_DATE , A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKC_STI_ASSET_LINES_R_INT A WHERE A.TCL_ID IS NULL AND A.TAL_ID IS NOT NULL UNION ALL SELECT A.ID ID , A.TAL_ID TAL_ID, A.ASSET_ID ASSET_ID , A.ASSET_QUANTITY ASSET_QUANTITY , A.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , A.CREATED_BY CREATED_BY , A.CREATION_DATE CREATION_DATE , A.LAST_UPDATED_BY LAST_UPDATED_BY , A.LAST_UPDATE_DATE LAST_UPDATE_DATE , A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKC_STI_ASSET_LINES_INT A WHERE A.TCL_ID IS NULL AND A.TAL_ID IS NOT NULL UNION ALL SELECT A.ID ID , A.TAL_ID TAL_ID, A.ASSET_ID ASSET_ID , A.ASSET_QUANTITY ASSET_QUANTITY , A.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , A.CREATED_BY CREATED_BY , A.CREATION_DATE CREATION_DATE , A.LAST_UPDATED_BY LAST_UPDATED_BY , A.LAST_UPDATE_DATE LAST_UPDATE_DATE , A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKC_STI_ASSET_LINES_H_INT A WHERE A.TCL_ID IS NULL AND A.TAL_ID IS NOT NULL |