View: PA_TXN_INTERFACE_AUDIT

View Text

SELECT TXN_INTERFACE_ID
, TRANSACTION_SOURCE
, BATCH_NAME
, EXPENDITURE_ENDING_DATE
, EMPLOYEE_NUMBER
, ORGANIZATION_NAME
, EXPENDITURE_ITEM_DATE
, PROJECT_NUMBER
, TASK_NUMBER
, EXPENDITURE_TYPE
, NON_LABOR_RESOURCE
, NON_LABOR_RESOURCE_ORG_NAME
, QUANTITY
, RAW_COST
, EXPENDITURE_COMMENT
, TRANSACTION_STATUS_CODE
, TRANSACTION_REJECTION_CODE
, EXPENDITURE_ID
, ORIG_TRANSACTION_REFERENCE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, RAW_COST_RATE
, INTERFACE_ID
, UNMATCHED_NEGATIVE_TXN_FLAG
, EXPENDITURE_ITEM_ID
, ORG_ID
, DR_CODE_COMBINATION_ID
, CR_CODE_COMBINATION_ID
, CDL_SYSTEM_REFERENCE1
, CDL_SYSTEM_REFERENCE2
, CDL_SYSTEM_REFERENCE3
, GL_DATE
, BURDENED_COST
, BURDENED_COST_RATE
, SYSTEM_LINKAGE
, BEFORE_AFTER_FLAG
, UPDATED_BY
, UPDATE_DATE
, USER_TRANSACTION_SOURCE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, ORIG_EXP_TXN_REFERENCE1
, ORIG_USER_EXP_TXN_REFERENCE
, VENDOR_NUMBER
, ORIG_EXP_TXN_REFERENCE2
, ORIG_EXP_TXN_REFERENCE3
, OVERRIDE_TO_ORGANIZATION_NAME
, REVERSED_ORIG_TXN_REFERENCE
, BILLABLE_FLAG
, PERSON_BUSINESS_GROUP_NAME
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, ASSIGNMENT_NAME
, WORK_TYPE_NAME
, CDL_SYSTEM_REFERENCE4
, ACCRUAL_FLAG
, PROJECT_ID
, TASK_ID
, PERSON_ID
, ORGANIZATION_ID
, NON_LABOR_RESOURCE_ORG_ID
, VENDOR_ID
, OVERRIDE_TO_ORGANIZATION_ID
, ASSIGNMENT_ID
, WORK_TYPE_ID
, PERSON_BUSINESS_GROUP_ID
, PO_NUMBER
, PO_HEADER_ID
, PO_LINE_NUM
, PO_LINE_ID
, PERSON_TYPE
, PO_PRICE_TYPE
, WIP_RESOURCE_ID
, INVENTORY_ITEM_ID
, UNIT_OF_MEASURE
FROM PA_TXN_INTERFACE_AUDIT_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns