JV_TRANSACTIONS_ALL

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_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 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 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

TRANSACTION_ID

OBJECT_VERSION_NUMBER

HEADER_ID

LINE_NUM

APPLICATION_ID

SOURCE_APPLICATION_ID

TRANSACTION_STATUS_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

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

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, 101 SOURCE_APPLICATION_ID, j.TRANSACTION_STATUS_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.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, NULL 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.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 = -99 UNION ALL SELECT j.TRANSACTION_ID, j.OBJECT_VERSION_NUMBER, j.HEADER_ID, j.LINE_NUM, j.APPLICATION_ID, j.APPLICATION_ID SOURCE_APPLICATION_ID, j.TRANSACTION_STATUS_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.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, s.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.CREATED_BY, j.CREATION_DATE, j.LAST_UPDATED_BY, j.LAST_UPDATE_DATE, j.LAST_UPDATE_LOGIN FROM JV_TRANSACTIONS j, XLA_AE_LINES s WHERE j.APPLICATION_ID > 0 AND j.HEADER_ID = s.AE_HEADER_ID AND j.LINE_NUM = s.AE_LINE_NUM AND j.APPLICATION_ID = s.APPLICATION_ID 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_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.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, NULL 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.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

SQL_Statement

SELECT

j.TRANSACTION_ID,

j.OBJECT_VERSION_NUMBER,

j.HEADER_ID,

j.LINE_NUM,

j.APPLICATION_ID,

101 SOURCE_APPLICATION_ID,

j.TRANSACTION_STATUS_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.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,

NULL 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.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 = -99

UNION ALL

SELECT

j.TRANSACTION_ID,

j.OBJECT_VERSION_NUMBER,

j.HEADER_ID,

j.LINE_NUM,

j.APPLICATION_ID,

j.APPLICATION_ID SOURCE_APPLICATION_ID,

j.TRANSACTION_STATUS_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.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,

s.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.CREATED_BY,

j.CREATION_DATE,

j.LAST_UPDATED_BY,

j.LAST_UPDATE_DATE,

j.LAST_UPDATE_LOGIN

FROM JV_TRANSACTIONS j, XLA_AE_LINES s

WHERE j.APPLICATION_ID > 0

AND j.HEADER_ID = s.AE_HEADER_ID

AND j.LINE_NUM = s.AE_LINE_NUM

AND j.APPLICATION_ID = s.APPLICATION_ID

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_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.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,

NULL 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.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