OKC_STI_ASSET_TRANSACTIONS_V

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name

ID ASSET_TXN_EVENT_CODE ASSET_TXN_EVENT_DATE ASSET_ID ASSET_INV_ITEM_ID ASSET_SHIP_FROM_INV_ORG_ID ASSET_SOLD_BY_BU_ID ASSET_SOLD_TO_PARTY_ID ASSET_BILL_TO_ACCOUNT_ID ASSET_BILL_TO_ACCOUNT_SITE_ID ASSET_BILL_TO_ACT_SITE_USE_ID ASSET_SHIP_TO_PARTY_ID ASSET_SHIP_TO_PARTY_SITE_ID ASSET_SHIP_DATE ASSET_QUANTITY ASSET_QUANTITY_UOM_CODE ASSET_SALES_ORDER_SYSTEM_TYPE ASSET_SALES_ORDER_SYSTEM ASSET_SALES_ORDER_ID ASSET_SALES_ORDER_LINE_ID ASSET_SALES_ORDER_NUMBER ASSET_SALES_ORDER_LINE_NUM ASSET_TRANSFERER_PARTY_ID ASSET_PRIOR_QUANTITY ASSET_PRIOR_QUANTITY_UOM_CODE ASSET_TXN_HOLD ASSET_TRANSACTION_ID ASSET_SOURCE_TXN_TIMESTAMP BU_ID ITEM_VALIDATION_ORG_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN TXN_EXEC_SEQ_ID TXN_TIMESTAMP TXN_SOURCE_CODE TXN_BATCH_ID TXN_XFR_BATCH_ID TXN_TYPE_CODE TXN_CREATE_CONTRACT TXN_REQUEST_ID TXN_REQUEST_ROW_NUM TXN_REPROCESS_REQUEST_ID TXN_REPROCESS_ROW_NUM TXN_PROCESS_PHASE ASSET_REPLACED_BY_ID ASSET_RETURN_DATE ASSET_REPLACEMENT_PROCESS ASSET_REPLACEMENT_PHASE ASSET_RETURN_ORDER_ID ASSET_RETURN_ORDER_LINE_ID ASSET_RETURN_ORDER_NUMBER ASSET_RETURN_ORDER_LINE_NUM TAL_ID

Query

SQL_Statement

SELECT A.ID ID , A.ASSET_TXN_EVENT_CODE ASSET_TXN_EVENT_CODE , A.ASSET_TXN_EVENT_DATE ASSET_TXN_EVENT_DATE , A.ASSET_ID ASSET_ID , A.ASSET_INV_ITEM_ID ASSET_INV_ITEM_ID , A.ASSET_SHIP_FROM_INV_ORG_ID ASSET_SHIP_FROM_INV_ORG_ID , A.ASSET_SOLD_BY_BU_ID ASSET_SOLD_BY_BU_ID , A.ASSET_SOLD_TO_PARTY_ID ASSET_SOLD_TO_PARTY_ID , A.ASSET_BILL_TO_ACCOUNT_ID ASSET_BILL_TO_ACCOUNT_ID , A.ASSET_BILL_TO_ACCOUNT_SITE_ID ASSET_BILL_TO_ACCOUNT_SITE_ID , A.ASSET_BILL_TO_ACT_SITE_USE_ID ASSET_BILL_TO_ACT_SITE_USE_ID , A.ASSET_SHIP_TO_PARTY_ID ASSET_SHIP_TO_PARTY_ID , A.ASSET_SHIP_TO_PARTY_SITE_ID ASSET_SHIP_TO_PARTY_SITE_ID , A.ASSET_SHIP_DATE ASSET_SHIP_DATE , A.ASSET_QUANTITY ASSET_QUANTITY , A.ASSET_QUANTITY_UOM_CODE ASSET_QUANTITY_UOM_CODE , A.ASSET_SALES_ORDER_SYSTEM_TYPE ASSET_SALES_ORDER_SYSTEM_TYPE , A.ASSET_SALES_ORDER_SYSTEM ASSET_SALES_ORDER_SYSTEM , A.ASSET_SALES_ORDER_ID ASSET_SALES_ORDER_ID , A.ASSET_SALES_ORDER_LINE_ID ASSET_SALES_ORDER_LINE_ID , A.ASSET_SALES_ORDER_NUMBER ASSET_SALES_ORDER_NUMBER , A.ASSET_SALES_ORDER_LINE_NUM ASSET_SALES_ORDER_LINE_NUM , A.ASSET_TRANSFERER_PARTY_ID ASSET_TRANSFERER_PARTY_ID , A.ASSET_PRIOR_QUANTITY ASSET_PRIOR_QUANTITY , A.ASSET_PRIOR_QUANTITY_UOM_CODE ASSET_PRIOR_QUANTITY_UOM_CODE , A.ASSET_TXN_HOLD ASSET_TXN_HOLD , A.ASSET_TRANSACTION_ID ASSET_TRANSACTION_ID , A.ASSET_SOURCE_TXN_TIMESTAMP ASSET_SOURCE_TXN_TIMESTAMP , A.BU_ID BU_ID , A.ASSET_ITEM_VAL_ORG_ID ITEM_VALIDATION_ORG_ID , 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 , T.TXN_EXEC_SEQ_ID TXN_EXEC_SEQ_ID , T.TXN_TIMESTAMP TXN_TIMESTAMP , T.TXN_SOURCE_CODE TXN_SOURCE_CODE , T.TXN_BATCH_ID TXN_BATCH_ID , T.TXN_XFR_BATCH_ID TXN_XFR_BATCH_ID , T.TXN_TYPE_CODE TXN_TYPE_CODE , T.TXN_CREATE_CONTRACT TXN_CREATE_CONTRACT , T.TXN_REQUEST_ID TXN_REQUEST_ID , T.TXN_REQUEST_ROW_NUM TXN_REQUEST_ROW_NUM , T.TXN_REPROCESS_REQUEST_ID TXN_REPROCESS_REQUEST_ID , T.TXN_REPROCESS_ROW_NUM TXN_REPROCESS_ROW_NUM, DECODE(A.ASSET_TXN_HOLD,'Y','HOLD','ERROR') TXN_PROCESS_PHASE, A.ASSET_REPLACED_BY_ID ASSET_REPLACED_BY_ID, A.ASSET_RETURN_DATE ASSET_RETURN_DATE, A.ASSET_REPLACEMENT_PROCESS ASSET_REPLACEMENT_PROCESS, A.ASSET_REPLACEMENT_PHASE ASSET_REPLACEMENT_PHASE, A.ASSET_RETURN_ORDER_ID ASSET_RETURN_ORDER_ID, A.ASSET_RETURN_ORDER_LINE_ID ASSET_RETURN_ORDER_LINE_ID, A.ASSET_RETURN_ORDER_NUMBER ASSET_RETURN_ORDER_NUMBER, A.ASSET_RETURN_ORDER_LINE_NUM ASSET_RETURN_ORDER_LINE_NUM, A.TAL_ID TAL_ID FROM OKC_STI_ASSET_LINES_R_INT A , OKC_STI_TRANSACTIONS_R_INT T WHERE A.TXN_ID = T.ID AND A.TCL_ID IS NULL AND A.TAL_ID IS NULL UNION ALL SELECT A.ID ID , A.ASSET_TXN_EVENT_CODE ASSET_TXN_EVENT_CODE , A.ASSET_TXN_EVENT_DATE ASSET_TXN_EVENT_DATE , A.ASSET_ID ASSET_ID , A.ASSET_INV_ITEM_ID ASSET_INV_ITEM_ID , A.ASSET_SHIP_FROM_INV_ORG_ID ASSET_SHIP_FROM_INV_ORG_ID , A.ASSET_SOLD_BY_BU_ID ASSET_SOLD_BY_BU_ID , A.ASSET_SOLD_TO_PARTY_ID ASSET_SOLD_TO_PARTY_ID , A.ASSET_BILL_TO_ACCOUNT_ID ASSET_BILL_TO_ACCOUNT_ID , A.ASSET_BILL_TO_ACCOUNT_SITE_ID ASSET_BILL_TO_ACCOUNT_SITE_ID , A.ASSET_BILL_TO_ACT_SITE_USE_ID ASSET_BILL_TO_ACT_SITE_USE_ID , A.ASSET_SHIP_TO_PARTY_ID ASSET_SHIP_TO_PARTY_ID , A.ASSET_SHIP_TO_PARTY_SITE_ID ASSET_SHIP_TO_PARTY_SITE_ID , A.ASSET_SHIP_DATE ASSET_SHIP_DATE , A.ASSET_QUANTITY ASSET_QUANTITY , A.ASSET_QUANTITY_UOM_CODE ASSET_QUANTITY_UOM_CODE , A.ASSET_SALES_ORDER_SYSTEM_TYPE ASSET_SALES_ORDER_SYSTEM_TYPE , A.ASSET_SALES_ORDER_SYSTEM ASSET_SALES_ORDER_SYSTEM , A.ASSET_SALES_ORDER_ID ASSET_SALES_ORDER_ID , A.ASSET_SALES_ORDER_LINE_ID ASSET_SALES_ORDER_LINE_ID , A.ASSET_SALES_ORDER_NUMBER ASSET_SALES_ORDER_NUMBER , A.ASSET_SALES_ORDER_LINE_NUM ASSET_SALES_ORDER_LINE_NUM , A.ASSET_TRANSFERER_PARTY_ID ASSET_TRANSFERER_PARTY_ID , A.ASSET_PRIOR_QUANTITY ASSET_PRIOR_QUANTITY , A.ASSET_PRIOR_QUANTITY_UOM_CODE ASSET_PRIOR_QUANTITY_UOM_CODE , A.ASSET_TXN_HOLD ASSET_TXN_HOLD , A.ASSET_TRANSACTION_ID ASSET_TRANSACTION_ID , A.ASSET_SOURCE_TXN_TIMESTAMP ASSET_SOURCE_TXN_TIMESTAMP , A.BU_ID BU_ID , A.ASSET_ITEM_VAL_ORG_ID ITEM_VALIDATION_ORG_ID , 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 , T.TXN_EXEC_SEQ_ID TXN_EXEC_SEQ_ID , T.TXN_TIMESTAMP TXN_TIMESTAMP , T.TXN_SOURCE_CODE TXN_SOURCE_CODE , T.TXN_BATCH_ID TXN_BATCH_ID , T.TXN_XFR_BATCH_ID TXN_XFR_BATCH_ID , T.TXN_TYPE_CODE TXN_TYPE_CODE , T.TXN_CREATE_CONTRACT TXN_CREATE_CONTRACT , T.TXN_REQUEST_ID TXN_REQUEST_ID , T.TXN_REQUEST_ROW_NUM TXN_REQUEST_ROW_NUM , T.TXN_REPROCESS_REQUEST_ID TXN_REPROCESS_REQUEST_ID , T.TXN_REPROCESS_ROW_NUM TXN_REPROCESS_ROW_NUM, 'PENDING' TXN_PROCESS_PHASE, A.ASSET_REPLACED_BY_ID ASSET_REPLACED_BY_ID, A.ASSET_RETURN_DATE ASSET_RETURN_DATE, A.ASSET_REPLACEMENT_PROCESS ASSET_REPLACEMENT_PROCESS, A.ASSET_REPLACEMENT_PHASE ASSET_REPLACEMENT_PHASE, A.ASSET_RETURN_ORDER_ID ASSET_RETURN_ORDER_ID, A.ASSET_RETURN_ORDER_LINE_ID ASSET_RETURN_ORDER_LINE_ID, A.ASSET_RETURN_ORDER_NUMBER ASSET_RETURN_ORDER_NUMBER, A.ASSET_RETURN_ORDER_LINE_NUM ASSET_RETURN_ORDER_LINE_NUM, A.TAL_ID TAL_ID FROM OKC_STI_ASSET_LINES_INT A , OKC_STI_TRANSACTIONS_INT T WHERE A.TXN_ID = T.ID AND A.TCL_ID IS NULL AND A.TAL_ID IS NULL UNION ALL SELECT A.ID ID , A.ASSET_TXN_EVENT_CODE ASSET_TXN_EVENT_CODE , A.ASSET_TXN_EVENT_DATE ASSET_TXN_EVENT_DATE , A.ASSET_ID ASSET_ID , A.ASSET_INV_ITEM_ID ASSET_INV_ITEM_ID , A.ASSET_SHIP_FROM_INV_ORG_ID ASSET_SHIP_FROM_INV_ORG_ID , A.ASSET_SOLD_BY_BU_ID ASSET_SOLD_BY_BU_ID , A.ASSET_SOLD_TO_PARTY_ID ASSET_SOLD_TO_PARTY_ID , A.ASSET_BILL_TO_ACCOUNT_ID ASSET_BILL_TO_ACCOUNT_ID , A.ASSET_BILL_TO_ACCOUNT_SITE_ID ASSET_BILL_TO_ACCOUNT_SITE_ID , A.ASSET_BILL_TO_ACT_SITE_USE_ID ASSET_BILL_TO_ACT_SITE_USE_ID , A.ASSET_SHIP_TO_PARTY_ID ASSET_SHIP_TO_PARTY_ID , A.ASSET_SHIP_TO_PARTY_SITE_ID ASSET_SHIP_TO_PARTY_SITE_ID , A.ASSET_SHIP_DATE ASSET_SHIP_DATE , A.ASSET_QUANTITY ASSET_QUANTITY , A.ASSET_QUANTITY_UOM_CODE ASSET_QUANTITY_UOM_CODE , A.ASSET_SALES_ORDER_SYSTEM_TYPE ASSET_SALES_ORDER_SYSTEM_TYPE , A.ASSET_SALES_ORDER_SYSTEM ASSET_SALES_ORDER_SYSTEM , A.ASSET_SALES_ORDER_ID ASSET_SALES_ORDER_ID , A.ASSET_SALES_ORDER_LINE_ID ASSET_SALES_ORDER_LINE_ID , A.ASSET_SALES_ORDER_NUMBER ASSET_SALES_ORDER_NUMBER , A.ASSET_SALES_ORDER_LINE_NUM ASSET_SALES_ORDER_LINE_NUM , A.ASSET_TRANSFERER_PARTY_ID ASSET_TRANSFERER_PARTY_ID , A.ASSET_PRIOR_QUANTITY ASSET_PRIOR_QUANTITY , A.ASSET_PRIOR_QUANTITY_UOM_CODE ASSET_PRIOR_QUANTITY_UOM_CODE , A.ASSET_TXN_HOLD ASSET_TXN_HOLD , A.ASSET_TRANSACTION_ID ASSET_TRANSACTION_ID , A.ASSET_SOURCE_TXN_TIMESTAMP ASSET_SOURCE_TXN_TIMESTAMP , A.BU_ID BU_ID , A.ASSET_ITEM_VAL_ORG_ID ITEM_VALIDATION_ORG_ID , 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 , T.TXN_EXEC_SEQ_ID TXN_EXEC_SEQ_ID , T.TXN_TIMESTAMP TXN_TIMESTAMP , T.TXN_SOURCE_CODE TXN_SOURCE_CODE , T.TXN_BATCH_ID TXN_BATCH_ID , T.TXN_XFR_BATCH_ID TXN_XFR_BATCH_ID , T.TXN_TYPE_CODE TXN_TYPE_CODE , T.TXN_CREATE_CONTRACT TXN_CREATE_CONTRACT , T.TXN_REQUEST_ID TXN_REQUEST_ID , T.TXN_REQUEST_ROW_NUM TXN_REQUEST_ROW_NUM , T.TXN_REPROCESS_REQUEST_ID TXN_REPROCESS_REQUEST_ID , T.TXN_REPROCESS_ROW_NUM TXN_REPROCESS_ROW_NUM, 'PROCESSED' TXN_PROCESS_PHASE, A.ASSET_REPLACED_BY_ID ASSET_REPLACED_BY_ID, A.ASSET_RETURN_DATE ASSET_RETURN_DATE, A.ASSET_REPLACEMENT_PROCESS ASSET_REPLACEMENT_PROCESS, A.ASSET_REPLACEMENT_PHASE ASSET_REPLACEMENT_PHASE, A.ASSET_RETURN_ORDER_ID ASSET_RETURN_ORDER_ID, A.ASSET_RETURN_ORDER_LINE_ID ASSET_RETURN_ORDER_LINE_ID, A.ASSET_RETURN_ORDER_NUMBER ASSET_RETURN_ORDER_NUMBER, A.ASSET_RETURN_ORDER_LINE_NUM ASSET_RETURN_ORDER_LINE_NUM, A.TAL_ID TAL_ID FROM OKC_STI_ASSET_LINES_H_INT A , OKC_STI_TRANSACTIONS_H_INT T WHERE A.TXN_ID = T.ID AND A.TCL_ID IS NULL AND A.TAL_ID IS NULL