OKC_STI_ASSET_TXN_DETAILS_V

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name
ID TAL_ID ASSET_ID ASSET_QUANTITY OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

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