IBY_XCC_PAYMENT_EXTRACT_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

DATA_SET_ID SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 TRANSACTION_NUMBER 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_GROUP_CODE LINE_NUM LEDGER_ID BUSINESS_UNIT_ID DESTINATION_TYPE_CODE DOCUMENT_TYPE_CODE TRANSACTION_SOURCE_CODE TRANSACTION_SUBTYPE_CODE JE_SOURCE_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 LIQUIDATION_DATE LIQUIDATION_QUANTITY LIQUIDATION_AMOUNT 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 STATISTICAL_AMOUNT BUDGET_CCID VENDOR_ID INVENTORY_ITEM_ID ORDER_TYPE_INFO 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 CONTROL_BUDGET_ID PJC_FUNDING_SOURCE

Query

SQL_Statement

SELECT IXE.DATA_SET_ID DATA_SET_ID, IXE.SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_1, ' ' SOURCE_HEADER_ID_2, IXE.TRANSACTION_NUMBER TRANSACTION_NUMBER, IXE.SOURCE_LINE_ID_1 SOURCE_LINE_ID_1, IXE.SOURCE_LINE_ID_2 SOURCE_LINE_ID_2, IXE.SOURCE_LINE_ID_3 SOURCE_LINE_ID_3, ' ' SOURCE_LINE_ID_4, ' ' SOURCE_LINE_ID_5, ' ' SOURCE_LINE_ID_6, null LINE_GROUP_CODE, row_number() OVER (ORDER BY IPA.PAYMENT_AMOUNT, IXE.ENTERED_AMOUNT) LINE_NUM, IXE.LEDGER_ID LEDGER_ID, IXE.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, null DESTINATION_TYPE_CODE, null DOCUMENT_TYPE_CODE, null TRANSACTION_SOURCE_CODE, IXE.TRANSACTION_SUBTYPE_CODE TRANSACTION_SUBTYPE_CODE, null JE_SOURCE_CODE, null JE_CATEGORY_CODE, IXE.BUDGET_DATE BUDGET_DATE, IXE.ACCOUNTING_DATE ACCOUNTING_DATE, null ENCUMBRANCE_TYPE_CODE, IXE.ENTERED_CURRENCY ENTERED_CURRENCY, null UOM_CODE, null QUANTITY, TO_NUMBER(NULL) PRICE, IXE.ENTERED_AMOUNT ENTERED_AMOUNT, null CONVERSION_TYPE_CODE, TO_DATE(NULL) CONVERSION_DATE, TO_NUMBER(NULL) LEDGER_AMOUNT, TO_DATE(NULL) LIQUIDATION_DATE, null LIQUIDATION_QUANTITY, TO_NUMBER(NULL) LIQUIDATION_AMOUNT, null LIQUIDATION_TRANS_TYPE_CODE, null LIQUIDATION_LINE_ID_1, null LIQUIDATION_LINE_ID_2, null LIQUIDATION_LINE_ID_3, null LIQUIDATION_LINE_ID_4, null LIQUIDATION_LINE_ID_5, null LIQUIDATION_LINE_ID_6, null STATISTICAL_AMOUNT, TO_NUMBER(NULL) BUDGET_CCID, TO_NUMBER(NULL) VENDOR_ID, TO_NUMBER(NULL) INVENTORY_ITEM_ID, null ORDER_TYPE_INFO, IXE.SOURCE_LINE_ID_3 CODE_COMBINATION_ID, TO_NUMBER(NULL) PJC_PROJECT_ID, TO_NUMBER(NULL) PJC_TASK_ID, TO_NUMBER(NULL) PJC_RESOURCE_ID, TO_NUMBER(NULL) PJC_CONTRACT_ID, TO_NUMBER(NULL) PJC_CONTRACT_LINE_ID, TO_NUMBER(NULL) PJC_FUNDING_ALLOCATION_ID, null PJC_BILLABLE_FLAG, null PJC_CAPITALIZABLE_FLAG, TO_NUMBER(NULL) PJC_EXPENDITURE_TYPE_ID, TO_DATE(NULL) PJC_EXPENDITURE_ITEM_DATE, TO_NUMBER(NULL) PJC_ORGANIZATION_ID, TO_NUMBER(NULL) PJC_WORK_TYPE_ID, TO_NUMBER(NULL) CONTROL_BUDGET_ID, null PJC_FUNDING_SOURCE FROM IBY_XCC_EXTRACT IXE LEFT OUTER JOIN IBY_PAYMENTS_ALL IPA ON (IXE.PAYMENT_SERVICE_REQUEST_ID = IPA.PAYMENT_SERVICE_REQUEST_ID AND IXE.SOURCE_HEADER_ID_1 = IPA.PAYMENT_ID )