PO_XCC_DATA

Details

Schema: FUSION
Object owner: PO
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_FUNDING_SOURCE PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID CONTROL_BUDGET_ID PJC_BURDEN_ACTION_CODE PO_VERSION_ID

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_FUNDING_SOURCE

PJC_EXPENDITURE_TYPE_ID

PJC_EXPENDITURE_ITEM_DATE

PJC_ORGANIZATION_ID

PJC_WORK_TYPE_ID

CONTROL_BUDGET_ID

PJC_BURDEN_ACTION_CODE

PO_VERSION_ID

Query

SQL_Statement
SELECT PO_BCEA_DATA.DATA_SET_ID, to_char(PO_BCEA_DATA.PO_HEADER_ID) SOURCE_HEADER_ID_1, to_char(PO_BCEA_DATA.PO_VERSION_ID) SOURCE_HEADER_ID_2, PO_BCEA_DATA.DOCUMENT_NUMBER TRANSACTION_NUMBER, to_char(PO_BCEA_DATA.PO_LINE_ID) SOURCE_LINE_ID_1, to_char(PO_BCEA_DATA.PO_LINE_LOCATION_ID) SOURCE_LINE_ID_2, to_char(PO_BCEA_DATA.PO_DISTRIBUTION_ID) SOURCE_LINE_ID_3, to_char(decode(BC_EVENT, 'FINALLY_CLOSE_PO', PO_BCEA_DATA.DATA_SET_ID ,'CF_FINALLY_CLOSE_PO', PO_BCEA_DATA.DATA_SET_ID ,'REOPEN_PO',PO_BCEA_DATA.DATA_SET_ID,'CF_REOPEN_PO',PO_BCEA_DATA.DATA_SET_ID,PO_BCEA_DATA.PO_VERSION_ID) ) SOURCE_LINE_ID_4, to_char(decode(PO_BCEA_DATA.RESERVATION_BACKOUT_FLAG,'N',' ',PO_BCEA_DATA.RESERVATION_BACKOUT_FLAG) ) SOURCE_LINE_ID_5, ' ' SOURCE_LINE_ID_6, PO_BCEA_DATA.LINE_GROUP_CODE, PO_BCEA_DATA.LINE_NUMBER LINE_NUM, PO_BCEA_DATA.PRIMARY_LEDGER_ID LEDGER_ID, PO_BCEA_DATA.REQ_BU_ID BUSINESS_UNIT_ID, PO_BCEA_DATA.DESTINATION_TYPE_CODE, null DOCUMENT_TYPE_CODE, null TRANSACTION_SOURCE_CODE, PO_BCEA_DATA.TRANSACTION_SUBTYPE_CODE, null JE_SOURCE_CODE, null JE_CATEGORY_CODE, PO_BCEA_DATA.BUDGET_DATE, PO_BCEA_DATA.BUDGET_DATE ACCOUNTING_DATE, null ENCUMBRANCE_TYPE_CODE, PO_BCEA_DATA.CURRENCY_CODE ENTERED_CURRENCY, PO_BCEA_DATA.UOM_CODE, PO_BCEA_DATA.DISTRIBUTION_QUANTITY QUANTITY, PO_BCEA_DATA.UNIT_PRICE PRICE, PO_BCEA_DATA.DISTRIBUTION_AMOUNT ENTERED_AMOUNT, null CONVERSION_TYPE_CODE, PO_BCEA_DATA.BUDGET_DATE CONVERSION_DATE, (PO_BCEA_DATA.DISTRIBUTION_AMOUNT * PO_BCEA_DATA.LEDGER_CURRENCY_RATE) LEDGER_AMOUNT, PO_BCEA_DATA.LIQUIDATION_DATE LIQUIDATION_DATE, PO_BCEA_DATA.BACKING_REQ_QUANTITY LIQUIDATION_QUANTITY, PO_BCEA_DATA.BACKING_REQ_AMOUNT LIQUIDATION_AMOUNT, 'REQUISITION' LIQUIDATION_TRANS_TYPE_CODE, nvl(to_char(PO_BCEA_DATA.BACKING_REQ_LINE_ID),' ') LIQUIDATION_LINE_ID_1, nvl(to_char(PO_BCEA_DATA.BACKING_REQ_DIST_ID),' ') 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, PO_BCEA_DATA.VENDOR_ID, PO_BCEA_DATA.ITEM_ID INVENTORY_ITEM_ID, PO_BCEA_DATA.ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_INFO, PO_BCEA_DATA.CODE_COMBINATION_ID, PO_BCEA_DATA.PJC_PROJECT_ID, PO_BCEA_DATA.PJC_TASK_ID, TO_NUMBER(NULL) PJC_RESOURCE_ID, PO_BCEA_DATA.PJC_CONTRACT_ID, PO_BCEA_DATA.PJC_CONTRACT_LINE_ID, PO_BCEA_DATA.PJC_FUNDING_ALLOCATION_ID, NVL(PO_BCEA_DATA.PJC_BILLABLE_FLAG, 'N') as PJC_BILLABLE_FLAG, NVL(PO_BCEA_DATA.PJC_CAPITALIZABLE_FLAG, 'N') as PJC_CAPITALIZABLE_FLAG, PO_BCEA_DATA.PJC_RESERVED_ATTRIBUTE1 PJC_FUNDING_SOURCE, PO_BCEA_DATA.PJC_EXPENDITURE_TYPE_ID, PO_BCEA_DATA.PJC_EXPENDITURE_ITEM_DATE, PO_BCEA_DATA.PJC_ORGANIZATION_ID, PO_BCEA_DATA.PJC_WORK_TYPE_ID, TO_NUMBER(NULL) CONTROL_BUDGET_ID, PO_BCEA_DATA.PJC_BURDEN_ACTION_CODE, PO_BCEA_DATA.PO_VERSION_ID FROM PO_BCEA_DATA

SQL_Statement

SELECT

PO_BCEA_DATA.DATA_SET_ID,

to_char(PO_BCEA_DATA.PO_HEADER_ID) SOURCE_HEADER_ID_1,

to_char(PO_BCEA_DATA.PO_VERSION_ID) SOURCE_HEADER_ID_2,

PO_BCEA_DATA.DOCUMENT_NUMBER TRANSACTION_NUMBER,

to_char(PO_BCEA_DATA.PO_LINE_ID) SOURCE_LINE_ID_1,

to_char(PO_BCEA_DATA.PO_LINE_LOCATION_ID) SOURCE_LINE_ID_2,

to_char(PO_BCEA_DATA.PO_DISTRIBUTION_ID) SOURCE_LINE_ID_3,

to_char(decode(BC_EVENT, 'FINALLY_CLOSE_PO', PO_BCEA_DATA.DATA_SET_ID ,'CF_FINALLY_CLOSE_PO', PO_BCEA_DATA.DATA_SET_ID ,'REOPEN_PO',PO_BCEA_DATA.DATA_SET_ID,'CF_REOPEN_PO',PO_BCEA_DATA.DATA_SET_ID,PO_BCEA_DATA.PO_VERSION_ID) ) SOURCE_LINE_ID_4,

to_char(decode(PO_BCEA_DATA.RESERVATION_BACKOUT_FLAG,'N',' ',PO_BCEA_DATA.RESERVATION_BACKOUT_FLAG) ) SOURCE_LINE_ID_5,

' ' SOURCE_LINE_ID_6,

PO_BCEA_DATA.LINE_GROUP_CODE,

PO_BCEA_DATA.LINE_NUMBER LINE_NUM,

PO_BCEA_DATA.PRIMARY_LEDGER_ID LEDGER_ID,

PO_BCEA_DATA.REQ_BU_ID BUSINESS_UNIT_ID,

PO_BCEA_DATA.DESTINATION_TYPE_CODE,

null DOCUMENT_TYPE_CODE,

null TRANSACTION_SOURCE_CODE,

PO_BCEA_DATA.TRANSACTION_SUBTYPE_CODE,

null JE_SOURCE_CODE,

null JE_CATEGORY_CODE,

PO_BCEA_DATA.BUDGET_DATE,

PO_BCEA_DATA.BUDGET_DATE ACCOUNTING_DATE,

null ENCUMBRANCE_TYPE_CODE,

PO_BCEA_DATA.CURRENCY_CODE ENTERED_CURRENCY,

PO_BCEA_DATA.UOM_CODE,

PO_BCEA_DATA.DISTRIBUTION_QUANTITY QUANTITY,

PO_BCEA_DATA.UNIT_PRICE PRICE,

PO_BCEA_DATA.DISTRIBUTION_AMOUNT ENTERED_AMOUNT,

null CONVERSION_TYPE_CODE,

PO_BCEA_DATA.BUDGET_DATE CONVERSION_DATE,

(PO_BCEA_DATA.DISTRIBUTION_AMOUNT * PO_BCEA_DATA.LEDGER_CURRENCY_RATE) LEDGER_AMOUNT,

PO_BCEA_DATA.LIQUIDATION_DATE LIQUIDATION_DATE,

PO_BCEA_DATA.BACKING_REQ_QUANTITY LIQUIDATION_QUANTITY,

PO_BCEA_DATA.BACKING_REQ_AMOUNT LIQUIDATION_AMOUNT,

'REQUISITION' LIQUIDATION_TRANS_TYPE_CODE,

nvl(to_char(PO_BCEA_DATA.BACKING_REQ_LINE_ID),' ') LIQUIDATION_LINE_ID_1,

nvl(to_char(PO_BCEA_DATA.BACKING_REQ_DIST_ID),' ') 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,

PO_BCEA_DATA.VENDOR_ID,

PO_BCEA_DATA.ITEM_ID INVENTORY_ITEM_ID,

PO_BCEA_DATA.ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_INFO,

PO_BCEA_DATA.CODE_COMBINATION_ID,

PO_BCEA_DATA.PJC_PROJECT_ID,

PO_BCEA_DATA.PJC_TASK_ID,

TO_NUMBER(NULL) PJC_RESOURCE_ID,

PO_BCEA_DATA.PJC_CONTRACT_ID,

PO_BCEA_DATA.PJC_CONTRACT_LINE_ID,

PO_BCEA_DATA.PJC_FUNDING_ALLOCATION_ID,

NVL(PO_BCEA_DATA.PJC_BILLABLE_FLAG, 'N') as PJC_BILLABLE_FLAG,

NVL(PO_BCEA_DATA.PJC_CAPITALIZABLE_FLAG, 'N') as PJC_CAPITALIZABLE_FLAG,

PO_BCEA_DATA.PJC_RESERVED_ATTRIBUTE1 PJC_FUNDING_SOURCE,

PO_BCEA_DATA.PJC_EXPENDITURE_TYPE_ID,

PO_BCEA_DATA.PJC_EXPENDITURE_ITEM_DATE,

PO_BCEA_DATA.PJC_ORGANIZATION_ID,

PO_BCEA_DATA.PJC_WORK_TYPE_ID,

TO_NUMBER(NULL) CONTROL_BUDGET_ID,

PO_BCEA_DATA.PJC_BURDEN_ACTION_CODE,

PO_BCEA_DATA.PO_VERSION_ID

FROM

PO_BCEA_DATA