XCC_SIM_EXTRACT

Details

Schema: FUSION
Object owner: XCC
Object type: VIEW

Columns

Name
DATA_SET_ID TRANSACTION_TYPE_CODE SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 TRANSACTION_NUMBER DESTINATION_TYPE_CODE TRANSACTION_SOURCE_CODE DOCUMENT_TYPE_CODE JE_SOURCE_CODE LEDGER_ID BUSINESS_UNIT_ID SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 LINE_NUM LINE_GROUP_CODE TRANSACTION_SUBTYPE_CODE JE_CATEGORY_CODE BUDGET_DATE ACCOUNTING_DATE ENCUMBRANCE_TYPE_CODE ENTERED_CURRENCY UOM_CODE QUANTITY PRICE ENTERED_AMOUNT CONVERSION_TYPE_CODE CONVERSION_DATE LEDGER_AMOUNT STATISTICAL_AMOUNT LIQUIDATION_AMOUNT LIQUIDATION_DATE LIQUIDATION_QUANTITY LIQUIDATION_TRANS_TYPE_CODE LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_2 LIQUIDATION_LINE_ID_3 LIQUIDATION_LINE_ID_4 LIQUIDATION_LINE_ID_5 LIQUIDATION_LINE_ID_6 CONTROL_BUDGET_ID BUDGET_CCID VENDOR_ID ORDER_TYPE_INFO INVENTORY_ITEM_ID CODE_COMBINATION_ID CASH_CODE_COMBINATION_ID REVENUE_CODE_COMBINATION_ID PJC_PROJECT_ID PJC_TASK_ID PJC_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID PJC_FUNDING_SOURCE HEADER_GROUP_CODE SOURCE_LINE_TYPE_CODE

Name

DATA_SET_ID

TRANSACTION_TYPE_CODE

SOURCE_HEADER_ID_1

SOURCE_HEADER_ID_2

TRANSACTION_NUMBER

DESTINATION_TYPE_CODE

TRANSACTION_SOURCE_CODE

DOCUMENT_TYPE_CODE

JE_SOURCE_CODE

LEDGER_ID

BUSINESS_UNIT_ID

SOURCE_LINE_ID_1

SOURCE_LINE_ID_2

SOURCE_LINE_ID_3

SOURCE_LINE_ID_4

SOURCE_LINE_ID_5

SOURCE_LINE_ID_6

LINE_NUM

LINE_GROUP_CODE

TRANSACTION_SUBTYPE_CODE

JE_CATEGORY_CODE

BUDGET_DATE

ACCOUNTING_DATE

ENCUMBRANCE_TYPE_CODE

ENTERED_CURRENCY

UOM_CODE

QUANTITY

PRICE

ENTERED_AMOUNT

CONVERSION_TYPE_CODE

CONVERSION_DATE

LEDGER_AMOUNT

STATISTICAL_AMOUNT

LIQUIDATION_AMOUNT

LIQUIDATION_DATE

LIQUIDATION_QUANTITY

LIQUIDATION_TRANS_TYPE_CODE

LIQUIDATION_LINE_ID_1

LIQUIDATION_LINE_ID_2

LIQUIDATION_LINE_ID_3

LIQUIDATION_LINE_ID_4

LIQUIDATION_LINE_ID_5

LIQUIDATION_LINE_ID_6

CONTROL_BUDGET_ID

BUDGET_CCID

VENDOR_ID

ORDER_TYPE_INFO

INVENTORY_ITEM_ID

CODE_COMBINATION_ID

CASH_CODE_COMBINATION_ID

REVENUE_CODE_COMBINATION_ID

PJC_PROJECT_ID

PJC_TASK_ID

PJC_RESOURCE_ID

PJC_CONTRACT_ID

PJC_CONTRACT_LINE_ID

PJC_FUNDING_ALLOCATION_ID

PJC_BILLABLE_FLAG

PJC_CAPITALIZABLE_FLAG

PJC_EXPENDITURE_TYPE_ID

PJC_EXPENDITURE_ITEM_DATE

PJC_ORGANIZATION_ID

PJC_WORK_TYPE_ID

PJC_FUNDING_SOURCE

HEADER_GROUP_CODE

SOURCE_LINE_TYPE_CODE

Query

SQL_Statement
SELECT NVL(XCC_SIM_LINES.DATA_SET_ID, XCC_SIM_HEADERS.DATA_SET_ID) DATA_SET_ID, XCC_SIM_HEADERS.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE, XCC_SIM_HEADERS.SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_1, XCC_SIM_HEADERS.SOURCE_HEADER_ID_2 SOURCE_HEADER_ID_2, XCC_SIM_HEADERS.TRANSACTION_NUMBER TRANSACTION_NUMBER, XCC_SIM_HEADERS.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, XCC_SIM_HEADERS.TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE, XCC_SIM_HEADERS.DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE, XCC_SIM_HEADERS.JE_SOURCE_CODE JE_SOURCE_CODE, NVL(XCC_SIM_LINES.LEDGER_ID, XCC_SIM_HEADERS.LEDGER_ID) LEDGER_ID, NVL(XCC_SIM_LINES.BUSINESS_UNIT_ID, XCC_SIM_HEADERS.BUSINESS_UNIT_ID) BUSINESS_UNIT_ID, XCC_SIM_LINES.SOURCE_LINE_ID_1 SOURCE_LINE_ID_1, XCC_SIM_LINES.SOURCE_LINE_ID_2 SOURCE_LINE_ID_2, XCC_SIM_LINES.SOURCE_LINE_ID_3 SOURCE_LINE_ID_3, XCC_SIM_LINES.SOURCE_LINE_ID_4 SOURCE_LINE_ID_4, XCC_SIM_LINES.SOURCE_LINE_ID_5 SOURCE_LINE_ID_5, XCC_SIM_LINES.SOURCE_LINE_ID_6 SOURCE_LINE_ID_6, XCC_SIM_LINES.LINE_NUM LINE_NUM, XCC_SIM_LINES.LINE_GROUP_CODE LINE_GROUP_CODE, XCC_SIM_LINES.TRANSACTION_SUBTYPE_CODE TRANSACTION_SUBTYPE_CODE, XCC_SIM_LINES.JE_CATEGORY_CODE JE_CATEGORY_CODE, XCC_SIM_LINES.BUDGET_DATE BUDGET_DATE, XCC_SIM_LINES.ACCOUNTING_DATE ACCOUNTING_DATE, XCC_SIM_LINES.ENCUMBRANCE_TYPE_CODE ENCUMBRANCE_TYPE_CODE, XCC_SIM_LINES.ENTERED_CURRENCY ENTERED_CURRENCY, XCC_SIM_LINES.UOM_CODE UOM_CODE, XCC_SIM_LINES.QUANTITY QUANTITY, XCC_SIM_LINES.PRICE PRICE, XCC_SIM_LINES.ENTERED_AMOUNT ENTERED_AMOUNT, XCC_SIM_LINES.CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, XCC_SIM_LINES.CONVERSION_DATE CONVERSION_DATE, XCC_SIM_LINES.LEDGER_AMOUNT LEDGER_AMOUNT, XCC_SIM_LINES.STATISTICAL_AMOUNT STATISTICAL_AMOUNT, XCC_SIM_LINES.LIQUIDATION_AMOUNT LIQUIDATION_AMOUNT, XCC_SIM_LINES.LIQUIDATION_DATE LIQUIDATION_DATE, XCC_SIM_LINES.LIQUIDATION_QUANTITY LIQUIDATION_QUANTITY, XCC_SIM_LINES.LIQUIDATION_TRANS_TYPE_CODE LIQUIDATION_TRANS_TYPE_CODE, XCC_SIM_LINES.LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_1, XCC_SIM_LINES.LIQUIDATION_LINE_ID_2 LIQUIDATION_LINE_ID_2, XCC_SIM_LINES.LIQUIDATION_LINE_ID_3 LIQUIDATION_LINE_ID_3, XCC_SIM_LINES.LIQUIDATION_LINE_ID_4 LIQUIDATION_LINE_ID_4, XCC_SIM_LINES.LIQUIDATION_LINE_ID_5 LIQUIDATION_LINE_ID_5, XCC_SIM_LINES.LIQUIDATION_LINE_ID_6 LIQUIDATION_LINE_ID_6, XCC_SIM_LINES.CONTROL_BUDGET_ID CONTROL_BUDGET_ID, XCC_SIM_LINES.BUDGET_CCID BUDGET_CCID, XCC_SIM_LINES.VENDOR_ID VENDOR_ID, XCC_SIM_LINES.ORDER_TYPE_INFO ORDER_TYPE_INFO, XCC_SIM_LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, XCC_SIM_LINES.CODE_COMBINATION_ID CODE_COMBINATION_ID, XCC_SIM_LINES.CASH_CODE_COMBINATION_ID CASH_CODE_COMBINATION_ID, XCC_SIM_LINES.REVENUE_CODE_COMBINATION_ID REVENUE_CODE_COMBINATION_ID, XCC_SIM_LINES.PJC_PROJECT_ID PJC_PROJECT_ID, XCC_SIM_LINES.PJC_TASK_ID PJC_TASK_ID, XCC_SIM_LINES.PJC_RESOURCE_ID PJC_RESOURCE_ID, XCC_SIM_LINES.PJC_CONTRACT_ID PJC_CONTRACT_ID, XCC_SIM_LINES.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID, XCC_SIM_LINES.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID, XCC_SIM_LINES.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG, XCC_SIM_LINES.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG, XCC_SIM_LINES.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID, XCC_SIM_LINES.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE, XCC_SIM_LINES.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID, XCC_SIM_LINES.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID, XCC_SIM_LINES.PJC_FUNDING_SOURCE_ID PJC_FUNDING_SOURCE, XCC_SIM_HEADERS.HEADER_GROUP_CODE, XCC_SIM_LINES.SOURCE_LINE_TYPE_CODE FROM XCC_SIM_HEADERS, XCC_SIM_LINES WHERE XCC_SIM_HEADERS.TRANSACTION_TYPE_CODE = XCC_SIM_LINES.TRANSACTION_TYPE_CODE AND XCC_SIM_HEADERS.SOURCE_HEADER_ID_1 = XCC_SIM_LINES.SOURCE_HEADER_ID_1 AND XCC_SIM_HEADERS.SOURCE_HEADER_ID_2 = XCC_SIM_LINES.SOURCE_HEADER_ID_2

SQL_Statement

SELECT

NVL(XCC_SIM_LINES.DATA_SET_ID, XCC_SIM_HEADERS.DATA_SET_ID) DATA_SET_ID,

XCC_SIM_HEADERS.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE,

XCC_SIM_HEADERS.SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_1,

XCC_SIM_HEADERS.SOURCE_HEADER_ID_2 SOURCE_HEADER_ID_2,

XCC_SIM_HEADERS.TRANSACTION_NUMBER TRANSACTION_NUMBER,

XCC_SIM_HEADERS.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE,

XCC_SIM_HEADERS.TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE,

XCC_SIM_HEADERS.DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE,

XCC_SIM_HEADERS.JE_SOURCE_CODE JE_SOURCE_CODE,

NVL(XCC_SIM_LINES.LEDGER_ID, XCC_SIM_HEADERS.LEDGER_ID) LEDGER_ID,

NVL(XCC_SIM_LINES.BUSINESS_UNIT_ID, XCC_SIM_HEADERS.BUSINESS_UNIT_ID) BUSINESS_UNIT_ID,

XCC_SIM_LINES.SOURCE_LINE_ID_1 SOURCE_LINE_ID_1,

XCC_SIM_LINES.SOURCE_LINE_ID_2 SOURCE_LINE_ID_2,

XCC_SIM_LINES.SOURCE_LINE_ID_3 SOURCE_LINE_ID_3,

XCC_SIM_LINES.SOURCE_LINE_ID_4 SOURCE_LINE_ID_4,

XCC_SIM_LINES.SOURCE_LINE_ID_5 SOURCE_LINE_ID_5,

XCC_SIM_LINES.SOURCE_LINE_ID_6 SOURCE_LINE_ID_6,

XCC_SIM_LINES.LINE_NUM LINE_NUM,

XCC_SIM_LINES.LINE_GROUP_CODE LINE_GROUP_CODE,

XCC_SIM_LINES.TRANSACTION_SUBTYPE_CODE TRANSACTION_SUBTYPE_CODE,

XCC_SIM_LINES.JE_CATEGORY_CODE JE_CATEGORY_CODE,

XCC_SIM_LINES.BUDGET_DATE BUDGET_DATE,

XCC_SIM_LINES.ACCOUNTING_DATE ACCOUNTING_DATE,

XCC_SIM_LINES.ENCUMBRANCE_TYPE_CODE ENCUMBRANCE_TYPE_CODE,

XCC_SIM_LINES.ENTERED_CURRENCY ENTERED_CURRENCY,

XCC_SIM_LINES.UOM_CODE UOM_CODE,

XCC_SIM_LINES.QUANTITY QUANTITY,

XCC_SIM_LINES.PRICE PRICE,

XCC_SIM_LINES.ENTERED_AMOUNT ENTERED_AMOUNT,

XCC_SIM_LINES.CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE,

XCC_SIM_LINES.CONVERSION_DATE CONVERSION_DATE,

XCC_SIM_LINES.LEDGER_AMOUNT LEDGER_AMOUNT,

XCC_SIM_LINES.STATISTICAL_AMOUNT STATISTICAL_AMOUNT,

XCC_SIM_LINES.LIQUIDATION_AMOUNT LIQUIDATION_AMOUNT,

XCC_SIM_LINES.LIQUIDATION_DATE LIQUIDATION_DATE,

XCC_SIM_LINES.LIQUIDATION_QUANTITY LIQUIDATION_QUANTITY,

XCC_SIM_LINES.LIQUIDATION_TRANS_TYPE_CODE LIQUIDATION_TRANS_TYPE_CODE,

XCC_SIM_LINES.LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_1,

XCC_SIM_LINES.LIQUIDATION_LINE_ID_2 LIQUIDATION_LINE_ID_2,

XCC_SIM_LINES.LIQUIDATION_LINE_ID_3 LIQUIDATION_LINE_ID_3,

XCC_SIM_LINES.LIQUIDATION_LINE_ID_4 LIQUIDATION_LINE_ID_4,

XCC_SIM_LINES.LIQUIDATION_LINE_ID_5 LIQUIDATION_LINE_ID_5,

XCC_SIM_LINES.LIQUIDATION_LINE_ID_6 LIQUIDATION_LINE_ID_6,

XCC_SIM_LINES.CONTROL_BUDGET_ID CONTROL_BUDGET_ID,

XCC_SIM_LINES.BUDGET_CCID BUDGET_CCID,

XCC_SIM_LINES.VENDOR_ID VENDOR_ID,

XCC_SIM_LINES.ORDER_TYPE_INFO ORDER_TYPE_INFO,

XCC_SIM_LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

XCC_SIM_LINES.CODE_COMBINATION_ID CODE_COMBINATION_ID,

XCC_SIM_LINES.CASH_CODE_COMBINATION_ID CASH_CODE_COMBINATION_ID,

XCC_SIM_LINES.REVENUE_CODE_COMBINATION_ID REVENUE_CODE_COMBINATION_ID,

XCC_SIM_LINES.PJC_PROJECT_ID PJC_PROJECT_ID,

XCC_SIM_LINES.PJC_TASK_ID PJC_TASK_ID,

XCC_SIM_LINES.PJC_RESOURCE_ID PJC_RESOURCE_ID,

XCC_SIM_LINES.PJC_CONTRACT_ID PJC_CONTRACT_ID,

XCC_SIM_LINES.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID,

XCC_SIM_LINES.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID,

XCC_SIM_LINES.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG,

XCC_SIM_LINES.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG,

XCC_SIM_LINES.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID,

XCC_SIM_LINES.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE,

XCC_SIM_LINES.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID,

XCC_SIM_LINES.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID,

XCC_SIM_LINES.PJC_FUNDING_SOURCE_ID PJC_FUNDING_SOURCE,

XCC_SIM_HEADERS.HEADER_GROUP_CODE,

XCC_SIM_LINES.SOURCE_LINE_TYPE_CODE

FROM

XCC_SIM_HEADERS,

XCC_SIM_LINES

WHERE

XCC_SIM_HEADERS.TRANSACTION_TYPE_CODE = XCC_SIM_LINES.TRANSACTION_TYPE_CODE AND XCC_SIM_HEADERS.SOURCE_HEADER_ID_1 = XCC_SIM_LINES.SOURCE_HEADER_ID_1 AND XCC_SIM_HEADERS.SOURCE_HEADER_ID_2 = XCC_SIM_LINES.SOURCE_HEADER_ID_2