POR_REQ_XCC_DATA

Details

Schema: FUSION
Object owner: POR
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

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 POR_REQ_BCEA_DATA.DATA_SET_ID, TO_CHAR(POR_REQ_BCEA_DATA.REQUISITION_HEADER_ID) SOURCE_HEADER_ID_1, ' ' SOURCE_HEADER_ID_2, POR_REQ_BCEA_DATA.REQUISITION_NUMBER TRANSACTION_NUMBER, TO_CHAR(POR_REQ_BCEA_DATA.REQUISITION_LINE_ID) SOURCE_LINE_ID_1, TO_CHAR(POR_REQ_BCEA_DATA.DISTRIBUTION_ID) SOURCE_LINE_ID_2, DECODE(POR_REQ_BCEA_DATA.ACTION_CODE, 'REQ_PARTIAL_CANCEL', TO_CHAR(POR_REQ_BCEA_DATA.DATA_SET_ID), ' ') SOURCE_LINE_ID_3, ' ' SOURCE_LINE_ID_4, ' ' SOURCE_LINE_ID_5, ' ' SOURCE_LINE_ID_6, POR_REQ_BCEA_DATA.LINE_GROUP_CODE LINE_GROUP_CODE, POR_REQ_BCEA_DATA.LINE_NUMBER LINE_NUM, POR_REQ_BCEA_DATA.PRIMARY_LEDGER_ID LEDGER_ID, POR_REQ_BCEA_DATA.REQ_BU_ID BUSINESS_UNIT_ID, POR_REQ_BCEA_DATA.DESTINATION_TYPE_CODE, null DOCUMENT_TYPE_CODE, null TRANSACTION_SOURCE_CODE, POR_REQ_BCEA_DATA.TRANSACTION_SUBTYPE_CODE, null JE_SOURCE_CODE, null JE_CATEGORY_CODE, POR_REQ_BCEA_DATA.BUDGET_DATE BUDGET_DATE, POR_REQ_BCEA_DATA.BUDGET_DATE ACCOUNTING_DATE, null ENCUMBRANCE_TYPE_CODE, POR_REQ_BCEA_DATA.CURRENCY_CODE ENTERED_CURRENCY, POR_REQ_BCEA_DATA.UOM_CODE, POR_REQ_BCEA_DATA.DISTRIBUTION_QUANTITY QUANTITY, POR_REQ_BCEA_DATA.UNIT_PRICE PRICE, POR_REQ_BCEA_DATA.DISTRIBUTION_CURRENCY_AMOUNT + NVL(POR_REQ_BCEA_DATA.NONRECOVERABLE_CURRENCY_TAX, 0) ENTERED_AMOUNT, null CONVERSION_TYPE_CODE, null CONVERSION_DATE, POR_REQ_BCEA_DATA.DISTRIBUTION_AMOUNT + NVL(POR_REQ_BCEA_DATA.NONRECOVERABLE_TAX, 0) LEDGER_AMOUNT, TO_DATE(NULL) LIQUIDATION_DATE, TO_NUMBER(NULL) LIQUIDATION_QUANTITY, TO_NUMBER(NULL) LIQUIDATION_AMOUNT, NULL 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, TO_NUMBER(NULL) STATISTICAL_AMOUNT, TO_NUMBER(NULL) BUDGET_CCID, POR_REQ_BCEA_DATA.VENDOR_ID, POR_REQ_BCEA_DATA.ITEM_ID INVENTORY_ITEM_ID, TO_CHAR(POR_REQ_BCEA_DATA.ORDER_TYPE_LOOKUP_CODE) ORDER_TYPE_INFO, POR_REQ_BCEA_DATA.CODE_COMBINATION_ID, POR_REQ_BCEA_DATA.PJC_PROJECT_ID, POR_REQ_BCEA_DATA.PJC_TASK_ID, TO_NUMBER(NULL) PJC_RESOURCE_ID, POR_REQ_BCEA_DATA.PJC_CONTRACT_ID, POR_REQ_BCEA_DATA.PJC_CONTRACT_LINE_ID, POR_REQ_BCEA_DATA.PJC_FUNDING_ALLOCATION_ID, NVL(POR_REQ_BCEA_DATA.PJC_BILLABLE_FLAG, 'N') AS PJC_BILLABLE_FLAG, NVL(POR_REQ_BCEA_DATA.PJC_CAPITALIZABLE_FLAG, 'N') AS PJC_CAPITALIZABLE_FLAG, POR_REQ_BCEA_DATA.PJC_EXPENDITURE_TYPE_ID, POR_REQ_BCEA_DATA.PJC_EXPENDITURE_ITEM_DATE, POR_REQ_BCEA_DATA.PJC_ORGANIZATION_ID, POR_REQ_BCEA_DATA.PJC_WORK_TYPE_ID, TO_NUMBER(NULL) CONTROL_BUDGET_ID, POR_REQ_BCEA_DATA.PJC_FUNDING_SOURCE FROM POR_REQ_BCEA_DATA

SQL_Statement

SELECT

POR_REQ_BCEA_DATA.DATA_SET_ID,

TO_CHAR(POR_REQ_BCEA_DATA.REQUISITION_HEADER_ID) SOURCE_HEADER_ID_1,

' ' SOURCE_HEADER_ID_2,

POR_REQ_BCEA_DATA.REQUISITION_NUMBER TRANSACTION_NUMBER,

TO_CHAR(POR_REQ_BCEA_DATA.REQUISITION_LINE_ID) SOURCE_LINE_ID_1,

TO_CHAR(POR_REQ_BCEA_DATA.DISTRIBUTION_ID) SOURCE_LINE_ID_2,

DECODE(POR_REQ_BCEA_DATA.ACTION_CODE, 'REQ_PARTIAL_CANCEL',

TO_CHAR(POR_REQ_BCEA_DATA.DATA_SET_ID), ' ') SOURCE_LINE_ID_3,

' ' SOURCE_LINE_ID_4,

' ' SOURCE_LINE_ID_5,

' ' SOURCE_LINE_ID_6,

POR_REQ_BCEA_DATA.LINE_GROUP_CODE LINE_GROUP_CODE,

POR_REQ_BCEA_DATA.LINE_NUMBER LINE_NUM,

POR_REQ_BCEA_DATA.PRIMARY_LEDGER_ID LEDGER_ID,

POR_REQ_BCEA_DATA.REQ_BU_ID BUSINESS_UNIT_ID,

POR_REQ_BCEA_DATA.DESTINATION_TYPE_CODE,

null DOCUMENT_TYPE_CODE,

null TRANSACTION_SOURCE_CODE,

POR_REQ_BCEA_DATA.TRANSACTION_SUBTYPE_CODE,

null JE_SOURCE_CODE,

null JE_CATEGORY_CODE,

POR_REQ_BCEA_DATA.BUDGET_DATE BUDGET_DATE,

POR_REQ_BCEA_DATA.BUDGET_DATE ACCOUNTING_DATE,

null ENCUMBRANCE_TYPE_CODE,

POR_REQ_BCEA_DATA.CURRENCY_CODE ENTERED_CURRENCY,

POR_REQ_BCEA_DATA.UOM_CODE,

POR_REQ_BCEA_DATA.DISTRIBUTION_QUANTITY QUANTITY,

POR_REQ_BCEA_DATA.UNIT_PRICE PRICE,

POR_REQ_BCEA_DATA.DISTRIBUTION_CURRENCY_AMOUNT + NVL(POR_REQ_BCEA_DATA.NONRECOVERABLE_CURRENCY_TAX, 0) ENTERED_AMOUNT,

null CONVERSION_TYPE_CODE,

null CONVERSION_DATE,

POR_REQ_BCEA_DATA.DISTRIBUTION_AMOUNT + NVL(POR_REQ_BCEA_DATA.NONRECOVERABLE_TAX, 0) LEDGER_AMOUNT,

TO_DATE(NULL) LIQUIDATION_DATE,

TO_NUMBER(NULL) LIQUIDATION_QUANTITY,

TO_NUMBER(NULL) LIQUIDATION_AMOUNT,

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

TO_NUMBER(NULL) STATISTICAL_AMOUNT,

TO_NUMBER(NULL) BUDGET_CCID,

POR_REQ_BCEA_DATA.VENDOR_ID,

POR_REQ_BCEA_DATA.ITEM_ID INVENTORY_ITEM_ID,

TO_CHAR(POR_REQ_BCEA_DATA.ORDER_TYPE_LOOKUP_CODE) ORDER_TYPE_INFO,

POR_REQ_BCEA_DATA.CODE_COMBINATION_ID,

POR_REQ_BCEA_DATA.PJC_PROJECT_ID,

POR_REQ_BCEA_DATA.PJC_TASK_ID,

TO_NUMBER(NULL) PJC_RESOURCE_ID,

POR_REQ_BCEA_DATA.PJC_CONTRACT_ID,

POR_REQ_BCEA_DATA.PJC_CONTRACT_LINE_ID,

POR_REQ_BCEA_DATA.PJC_FUNDING_ALLOCATION_ID,

NVL(POR_REQ_BCEA_DATA.PJC_BILLABLE_FLAG, 'N') AS PJC_BILLABLE_FLAG,

NVL(POR_REQ_BCEA_DATA.PJC_CAPITALIZABLE_FLAG, 'N') AS PJC_CAPITALIZABLE_FLAG,

POR_REQ_BCEA_DATA.PJC_EXPENDITURE_TYPE_ID,

POR_REQ_BCEA_DATA.PJC_EXPENDITURE_ITEM_DATE,

POR_REQ_BCEA_DATA.PJC_ORGANIZATION_ID,

POR_REQ_BCEA_DATA.PJC_WORK_TYPE_ID,

TO_NUMBER(NULL) CONTROL_BUDGET_ID,

POR_REQ_BCEA_DATA.PJC_FUNDING_SOURCE

FROM

POR_REQ_BCEA_DATA