JV_TRANSACTIONS_ALL_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name

TRANSACTION_ID OBJECT_VERSION_NUMBER HEADER_ID LINE_NUM APPLICATION_ID SOURCE_APPLICATION_ID TRANSACTION_STATUS_CODE TRANSACTION_TYPE_CODE TRANSACTION_DATE JOINT_VENTURE_ID ORIGINAL_OWNER_DEFINITION OWNERSHIP_DEFINITION ORIGINAL_STAKEHOLDER_ID STAKEHOLDER_ID ASSIGNMENT_RULE_ID AGREEMENT_ID OVERHEAD_METHOD_ID TRANSACTION_SOURCE_CODE DISTRIBUTION_TYPE_CODE NOTES DISTRIBUTION_ONLY_FLAG ORIGINATED_FROM_JV_FLAG LEDGER_ID ACCOUNTING_PERIOD ACCOUNTING_DATE CODE_COMBINATION_ID ACCOUNTED_DEBIT ACCOUNTED_CREDIT ACCOUNTED_CURRENCY_CODE ENTERED_DEBIT ENTERED_CREDIT ENTERED_CURRENCY_CODE TRANSACTION_DESCRIPTION ACCOUNTING_CLASS_CODE PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ORGANIZATION_ID EXPENDITURE_BU_ID EXPENDITURE_ITEM_DATE SOURCE_INVOICE_NUM EVENT_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT j.TRANSACTION_ID, j.OBJECT_VERSION_NUMBER, j.HEADER_ID, j.LINE_NUM, j.APPLICATION_ID, CASE WHEN j.APPLICATION_ID = -99 THEN 101 ELSE j.APPLICATION_ID END SOURCE_APPLICATION_ID, j.TRANSACTION_STATUS_CODE, j.TRANSACTION_TYPE_CODE, j.TRANSACTION_DATE, j.JOINT_VENTURE_ID, j.ORIGINAL_OWNERSHIP_SHORT_NAME ORIGINAL_OWNER_DEFINITION, j.OWNERSHIP_PERCENT_SHORT_NAME OWNERSHIP_DEFINITION, j.ORIGINAL_STAKEHOLDER_ID, j.STAKEHOLDER_ID, j.ASSIGNMENT_RULE_ID, j.AGREEMENT_ID, NULL OVERHEAD_METHOD_ID, NULL TRANSACTION_SOURCE_CODE, NULL DISTRIBUTION_TYPE_CODE, NULL NOTES, j.DISTRIBUTION_ONLY_FLAG, j.ORIGINATED_FROM_JV_FLAG, j.LEDGER_ID, j.PERIOD_NAME ACCOUNTING_PERIOD, j.ACCOUNTING_DATE, j.CODE_COMBINATION_ID, j.ACCOUNTED_DEBIT, j.ACCOUNTED_CREDIT, j.ACCOUNTED_CURRENCY_CODE, j.ENTERED_DEBIT, j.ENTERED_CREDIT, j.ENTERED_CURRENCY_CODE, j.TRANSACTION_DESCRIPTION, j.ACCOUNTING_CLASS_CODE, j.PROJECT_ID, j.TASK_ID, j.EXPENDITURE_TYPE_ID, j.EXPENDITURE_ORGANIZATION_ID, j.EXPENDITURE_BU_ID, j.EXPENDITURE_ITEM_DATE, j.SOURCE_INVOICE_NUM, j.EVENT_TYPE_CODE, j.CREATED_BY, j.CREATION_DATE, j.LAST_UPDATED_BY, j.LAST_UPDATE_DATE, j.LAST_UPDATE_LOGIN FROM JV_TRANSACTIONS j WHERE j.APPLICATION_ID != -10568 UNION ALL SELECT j.TRANSACTION_ID, j.OBJECT_VERSION_NUMBER, j.HEADER_ID, j.LINE_NUM, j.APPLICATION_ID, ABS(j.APPLICATION_ID) SOURCE_APPLICATION_ID, j.TRANSACTION_STATUS_CODE, j.TRANSACTION_TYPE_CODE, j.TRANSACTION_DATE, j.JOINT_VENTURE_ID, j.ORIGINAL_OWNERSHIP_SHORT_NAME ORIGINAL_OWNER_DEFINITION, j.OWNERSHIP_PERCENT_SHORT_NAME OWNERSHIP_DEFINITION, j.ORIGINAL_STAKEHOLDER_ID, j.STAKEHOLDER_ID, NULL ASSIGNMENT_RULE_ID, j.AGREEMENT_ID, g.OVERHEAD_METHOD_ID, g.TRANSACTION_SOURCE_CODE, g.DISTRIBUTION_TYPE_CODE, g.NOTES, j.DISTRIBUTION_ONLY_FLAG, j.ORIGINATED_FROM_JV_FLAG, j.LEDGER_ID, j.PERIOD_NAME ACCOUNTING_PERIOD, j.ACCOUNTING_DATE, j.CODE_COMBINATION_ID, j.ACCOUNTED_DEBIT, j.ACCOUNTED_CREDIT, j.ACCOUNTED_CURRENCY_CODE, NULL ENTERED_DEBIT, NULL ENTERED_CREDIT, NULL ENTERED_CURRENCY_CODE, j.TRANSACTION_DESCRIPTION, j.ACCOUNTING_CLASS_CODE, j.PROJECT_ID, j.TASK_ID, j.EXPENDITURE_TYPE_ID, j.EXPENDITURE_ORGANIZATION_ID, j.EXPENDITURE_BU_ID, j.EXPENDITURE_ITEM_DATE, j.SOURCE_INVOICE_NUM, j.EVENT_TYPE_CODE, j.CREATED_BY, j.CREATION_DATE, j.LAST_UPDATED_BY, j.LAST_UPDATE_DATE, j.LAST_UPDATE_LOGIN FROM JV_TRANSACTIONS j, JV_GENERATED_TRANSACTIONS g WHERE j.APPLICATION_ID = -10568 AND j.HEADER_ID = g.HEADER_ID AND j.LINE_NUM = g.LINE_NUM