JV_DISTRIBUTIONS_ALL_V

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name

DISTRIBUTION_ID OBJECT_VERSION_NUMBER HEADER_ID LINE_NUM APPLICATION_ID SOURCE_APPLICATION_ID DISTRIBUTION_STATUS_CODE DISTRIBUTION_LINE_TYPE_CODE DISTRIBUTION_LINE_NUMBER DISTRIBUTION_TYPE_CODE TRANSACTION_ID TRANSACTION_SOURCE_CODE TRANSACTION_DATE ACCOUNTING_DATE ACCOUNTING_PERIOD LEDGER_ID CODE_COMBINATION_ID JOINT_VENTURE_ID OWNERSHIP_DEFINITION_ID ORIGINAL_OWNERSHIP_SHORT_NAME ORIGINAL_OWNERSHIP_START_DATE ORIGINAL_OWNERSHIP_END_DATE ORIGINAL_STAKEHOLDER_ID STAKEHOLDER_ID DIRECT_BILL_STAKEHOLDER_ID OWNERSHIP_PERCENTAGE ROUND_AMOUNT_FLAG DISTRIBUTION_ONLY_FLAG ACCOUNTED_DEBIT ACCOUNTED_CREDIT ENTERED_DEBIT ENTERED_CREDIT TRANSACTION_DESCRIPTION ASSIGNMENT_RULE_ID AGREEMENT_ID OVERHEAD_METHOD_ID NOTES ORIG_DISTRIBUTED_ACCTED_DR ORIG_DISTRIBUTED_ACCTED_CR DISTRIBUTED_ACCOUNTED_DR DISTRIBUTED_ACCOUNTED_CR ACCOUNTED_CURRENCY_CODE ORIG_DISTRIBUTED_ENTERED_DR ORIG_DISTRIBUTED_ENTERED_CR DISTRIBUTED_ENTERED_DEBIT DISTRIBUTED_ENTERED_CREDIT ENTERED_CURRENCY_CODE PARTNER_ACCOUNT_CCID TARGET_TRANSACTION_HEADER_CCID INVOICE_NUMBER INVOICE_DATE JOURNAL_NUMBER CONTRIBUTION_ID PARTNER_CONTRIBUTION_ID PROJECT_COSTING_STATUS_CODE PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ORGANIZATION_ID EXPENDITURE_BU_ID EXPENDITURE_ITEM_DATE CREATED_BY_JV_FLAG STAKEHOLDER_RPTG_HEADER_ID STAKEHOLDER_RPTG_LEDGER_ID STAKEHOLDER_RPTG_STATUS_CODE CHANGE_REASON_CODE CHANGE_REASON_ADDITIONAL_TEXT ORIGINAL_DISTRIBUTION_ID CHILD_REQUEST_ID SOURCE_DISTRIBUTION_NUM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT d.DISTRIBUTION_ID, d.OBJECT_VERSION_NUMBER, t.HEADER_ID, t.LINE_NUM, t.APPLICATION_ID, CASE WHEN t.APPLICATION_ID = -99 THEN 101 ELSE t.APPLICATION_ID END SOURCE_APPLICATION_ID, d.DISTRIBUTION_STATUS_CODE, d.DISTRIBUTION_LINE_TYPE_CODE, d.DISTRIBUTION_LINE_NUMBER, d.DISTRIBUTION_TYPE_CODE, d.TRANSACTION_ID, null TRANSACTION_SOURCE_CODE, d.TRANSACTION_DATE, t.ACCOUNTING_DATE, t.PERIOD_NAME ACCOUNTING_PERIOD, t.LEDGER_ID, t.CODE_COMBINATION_ID, d.JOINT_VENTURE_ID, d.OWNERSHIP_PERCENTAGE_ID OWNERSHIP_DEFINITION_ID, t.ORIGINAL_OWNERSHIP_SHORT_NAME, d.OWNERSHIP_START_DATE ORIGINAL_OWNERSHIP_START_DATE, d.OWNERSHIP_END_DATE ORIGINAL_OWNERSHIP_END_DATE, d.ORIGINAL_STAKEHOLDER_ID, d.STAKEHOLDER_ID, t.STAKEHOLDER_ID DIRECT_BILL_STAKEHOLDER_ID, d.PERCENTAGE_OF_INTEREST OWNERSHIP_PERCENTAGE, d.ROUND_AMOUNT_FLAG, d.DISTRIBUTION_ONLY_FLAG, t.ACCOUNTED_DEBIT, t.ACCOUNTED_CREDIT, t.ENTERED_DEBIT, t.ENTERED_CREDIT, t.TRANSACTION_DESCRIPTION, t.ASSIGNMENT_RULE_ID, t.AGREEMENT_ID, null OVERHEAD_METHOD_ID, null NOTES, d.ORIG_DISTRIBUTED_AMOUNT_DEBIT ORIG_DISTRIBUTED_ACCTED_DR, d.ORIG_DISTRIBUTED_AMOUNT_CREDIT ORIG_DISTRIBUTED_ACCTED_CR, d.DISTRIBUTED_DEBIT_AMOUNT DISTRIBUTED_ACCOUNTED_DR, d.DISTRIBUTED_CREDIT_AMOUNT DISTRIBUTED_ACCOUNTED_CR, d.CURRENCY_CODE ACCOUNTED_CURRENCY_CODE, d.ORIG_DISTRIBUTED_ENTERED_DR, d.ORIG_DISTRIBUTED_ENTERED_CR, d.DISTRIBUTED_ENTERED_DEBIT, d.DISTRIBUTED_ENTERED_CREDIT, d.ENTERED_CURRENCY_CODE, d.PARTNER_ACCOUNT_CCID, d.TARGET_TRANSACTION_HEADER_CCID, d.TRX_NUMBER INVOICE_NUMBER, d.TRX_DATE INVOICE_DATE, d.TARGET_TRANSACTION_ID JOURNAL_NUMBER, d.CONTRIBUTION_ID, d.PARTNER_CONTRIBUTION_ID, d.PROJECT_COSTING_STATUS_CODE, t.PROJECT_ID, t.TASK_ID, t.EXPENDITURE_TYPE_ID, t.EXPENDITURE_ORGANIZATION_ID, t.EXPENDITURE_BU_ID, t.EXPENDITURE_ITEM_DATE, t.ORIGINATED_FROM_JV_FLAG CREATED_BY_JV_FLAG, d.STAKEHOLDER_RPTG_HEADER_ID, d.STAKEHOLDER_RPTG_LEDGER_ID, d.STAKEHOLDER_RPTG_STATUS_CODE, d.CHANGE_REASON_CODE, d.CHANGE_REASON_ADDITIONAL_TEXT, d.ORIGINAL_DISTRIBUTION_ID, d.CHILD_REQUEST_ID, d.SOURCE_DISTRIBUTION_NUM, d.CREATED_BY, d.CREATION_DATE, d.LAST_UPDATED_BY, d.LAST_UPDATE_DATE, d.LAST_UPDATE_LOGIN FROM JV_DISTRIBUTIONS d, JV_TRANSACTIONS t WHERE t.APPLICATION_ID != -10568 AND d.TRANSACTION_ID = t.TRANSACTION_ID UNION ALL SELECT d.DISTRIBUTION_ID, d.OBJECT_VERSION_NUMBER, t.HEADER_ID, t.LINE_NUM, t.APPLICATION_ID, ABS(t.APPLICATION_ID) SOURCE_APPLICATION_ID, d.DISTRIBUTION_STATUS_CODE, d.DISTRIBUTION_LINE_TYPE_CODE, d.DISTRIBUTION_LINE_NUMBER, d.DISTRIBUTION_TYPE_CODE, d.TRANSACTION_ID, g.TRANSACTION_SOURCE_CODE, d.TRANSACTION_DATE, t.ACCOUNTING_DATE, t.PERIOD_NAME ACCOUNTING_PERIOD, t.LEDGER_ID, t.CODE_COMBINATION_ID, d.JOINT_VENTURE_ID, d.OWNERSHIP_PERCENTAGE_ID OWNERSHIP_DEFINITION_ID, t.ORIGINAL_OWNERSHIP_SHORT_NAME, d.OWNERSHIP_START_DATE ORIGINAL_OWNERSHIP_START_DATE, d.OWNERSHIP_END_DATE ORIGINAL_OWNERSHIP_END_DATE, d.ORIGINAL_STAKEHOLDER_ID, d.STAKEHOLDER_ID, t.STAKEHOLDER_ID DIRECT_BILL_STAKEHOLDER_ID, d.PERCENTAGE_OF_INTEREST OWNERSHIP_PERCENTAGE, d.ROUND_AMOUNT_FLAG, d.DISTRIBUTION_ONLY_FLAG, t.ACCOUNTED_DEBIT, t.ACCOUNTED_CREDIT, t.ENTERED_DEBIT, t.ENTERED_CREDIT, t.TRANSACTION_DESCRIPTION, t.ASSIGNMENT_RULE_ID, t.AGREEMENT_ID, g.OVERHEAD_METHOD_ID, g.NOTES, d.ORIG_DISTRIBUTED_AMOUNT_DEBIT ORIG_DISTRIBUTED_ACCTED_DR, d.ORIG_DISTRIBUTED_AMOUNT_CREDIT ORIG_DISTRIBUTED_ACCTED_CR, d.DISTRIBUTED_DEBIT_AMOUNT DISTRIBUTED_ACCOUNTED_DR, d.DISTRIBUTED_CREDIT_AMOUNT DISTRIBUTED_ACCOUNTED_CR, d.CURRENCY_CODE ACCOUNTED_CURRENCY_CODE, d.ORIG_DISTRIBUTED_ENTERED_DR, d.ORIG_DISTRIBUTED_ENTERED_CR, d.DISTRIBUTED_ENTERED_DEBIT, d.DISTRIBUTED_ENTERED_CREDIT, d.ENTERED_CURRENCY_CODE, d.PARTNER_ACCOUNT_CCID, d.TARGET_TRANSACTION_HEADER_CCID, d.TRX_NUMBER INVOICE_NUMBER, d.TRX_DATE INVOICE_DATE, d.TARGET_TRANSACTION_ID JOURNAL_NUMBER, d.CONTRIBUTION_ID, d.PARTNER_CONTRIBUTION_ID, d.PROJECT_COSTING_STATUS_CODE, t.PROJECT_ID, t.TASK_ID, t.EXPENDITURE_TYPE_ID, t.EXPENDITURE_ORGANIZATION_ID, t.EXPENDITURE_BU_ID, t.EXPENDITURE_ITEM_DATE, t.ORIGINATED_FROM_JV_FLAG CREATED_BY_JV_FLAG, d.STAKEHOLDER_RPTG_HEADER_ID, d.STAKEHOLDER_RPTG_LEDGER_ID, d.STAKEHOLDER_RPTG_STATUS_CODE, d.CHANGE_REASON_CODE, d.CHANGE_REASON_ADDITIONAL_TEXT, d.ORIGINAL_DISTRIBUTION_ID, d.CHILD_REQUEST_ID, d.SOURCE_DISTRIBUTION_NUM, d.CREATED_BY, d.CREATION_DATE, d.LAST_UPDATED_BY, d.LAST_UPDATE_DATE, d.LAST_UPDATE_LOGIN FROM JV_DISTRIBUTIONS d, JV_TRANSACTIONS t, JV_GENERATED_TRANSACTIONS g WHERE t.APPLICATION_ID = -10568 AND d.TRANSACTION_ID = t.TRANSACTION_ID AND t.HEADER_ID = g.HEADER_ID AND t.LINE_NUM = g.LINE_NUM