CSE_TRANSACTIONS_V
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: VIEW
Columns
Name |
---|
TRANSACTION_ID OBJECT_VERSION_NUMBER SRC_SYSTEM_TYPE SRC_SYSTEM_ID SRC_TRANSACTION_DATE SRC_TRANSACTION_ID SRC_TRANSACTION_TYPE_ID SRC_TRANSACTION_TYPE SRC_TRANSACTION_QTY ITEM_ID ITEM_REVISION ITEM_ORGANIZATION_ID PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_DATE EXPENDITURE_ORGANIZATION_ID ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE |
Query
SQL_Statement |
---|
SELECT CT.TRANSACTION_ID TRANSACTION_ID, CT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CT.SRC_SYSTEM_TYPE SRC_SYSTEM_TYPE, CT.SRC_SYSTEM_ID SRC_SYSTEM_ID, CT.SRC_TRANSACTION_DATE SRC_TRANSACTION_DATE, CT.SRC_TRANSACTION_ID SRC_TRANSACTION_ID, CT.SRC_TRANSACTION_TYPE_ID SRC_TRANSACTION_TYPE_ID, CASE WHEN CT.SRC_SYSTEM_TYPE = 'ORA_INTERNAL' AND CT.SRC_SYSTEM_ID = 401 THEN (SELECT TRANSACTION_TYPE_NAME FROM INV_TRANSACTION_TYPES_VL WHERE TRANSACTION_TYPE_ID = CT.SRC_TRANSACTION_TYPE_ID) WHEN CT.SRC_SYSTEM_TYPE = 'ORA_INTERNAL' AND CT.SRC_SYSTEM_ID = 10493 THEN (SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'ORA_WIE_OP_TRANSACTION_TYPE' AND LOOKUP_CODE = CT.SRC_TRANSACTION_TYPE_ID) ELSE CT.SRC_TRANSACTION_TYPE END SRC_TRANSACTION_TYPE, CT.SRC_TRANSACTION_QTY SRC_TRANSACTION_QTY, CT.ITEM_ID ITEM_ID, CT.ITEM_REVISION ITEM_REVISION, CT.ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID, CT.PROJECT_ID PROJECT_ID, CT.TASK_ID TASK_ID, CT.EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, CT.EXPENDITURE_DATE EXPENDITURE_DATE, CT.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, CT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CT.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, CT.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, CT.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, CT.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, CT.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, CT.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, CT.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, CT.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, CT.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, CT.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, CT.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, CT.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, CT.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, CT.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, CT.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, CT.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, CT.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, CT.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, CT.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, CT.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, CT.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, CT.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, CT.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, CT.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, CT.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, CT.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, CT.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, CT.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, CT.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, CT.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, CT.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, CT.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, CT.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, CT.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, CT.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, CT.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, CT.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, CT.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, CT.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, CT.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, CT.CREATED_BY CREATED_BY, CT.CREATION_DATE CREATION_DATE, CT.LAST_UPDATED_BY LAST_UPDATED_BY, CT.LAST_UPDATE_DATE LAST_UPDATE_DATE, CT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CT.REQUEST_ID REQUEST_ID, CT.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, CT.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM CSE_TRANSACTIONS CT |