Product: | PA - Projects |
---|---|
Description: | Multi-org, single currency view |
Implementation/DBA Data: | Not implemented in this database |
SELECT MC.TXN_INTERFACE_ID
, PA1.RAW_COST
, PA1.RAW_COST_RATE
, PA1.BURDENED_COST
, PA1.BURDENED_COST_RATE
, PA1.ORIG_TRANSACTION_REFERENCE
, PA1.TRANSACTION_SOURCE
, PA1.BATCH_NAME
, PA1.EXPENDITURE_ENDING_DATE
, PA1.EMPLOYEE_NUMBER
, PA1.ORGANIZATION_NAME
, PA1.EXPENDITURE_ITEM_DATE
, PA1.PROJECT_NUMBER
, PA1.TASK_NUMBER
, PA1.EXPENDITURE_TYPE
, PA1.NON_LABOR_RESOURCE
, PA1.NON_LABOR_RESOURCE_ORG_NAME
, PA1.QUANTITY
, PA1.EXPENDITURE_COMMENT
, PA1.TRANSACTION_STATUS_CODE
, PA1.TRANSACTION_REJECTION_CODE
, PA1.EXPENDITURE_ID
, PA1.ATTRIBUTE_CATEGORY
, PA1.ATTRIBUTE1
, PA1.ATTRIBUTE2
, PA1.ATTRIBUTE3
, PA1.ATTRIBUTE4
, PA1.ATTRIBUTE5
, PA1.ATTRIBUTE6
, PA1.ATTRIBUTE7
, PA1.ATTRIBUTE8
, PA1.ATTRIBUTE9
, PA1.ATTRIBUTE10
, PA1.INTERFACE_ID
, PA1.UNMATCHED_NEGATIVE_TXN_FLAG
, PA1.EXPENDITURE_ITEM_ID
, PA1.ORG_ID
, PA1.DR_CODE_COMBINATION_ID
, PA1.CR_CODE_COMBINATION_ID
, PA1.CDL_SYSTEM_REFERENCE1
, PA1.CDL_SYSTEM_REFERENCE2
, PA1.CDL_SYSTEM_REFERENCE3
, PA1.GL_DATE
, PA1.SYSTEM_LINKAGE
, PA1.USER_TRANSACTION_SOURCE
, PA1.RECEIPT_CURRENCY_AMOUNT
, PA1.RECEIPT_CURRENCY_CODE
, PA1.RECEIPT_EXCHANGE_RATE
, PA1.DENOM_CURRENCY_CODE
, PA1.DENOM_RAW_COST
, PA1.DENOM_BURDENED_COST
, MC.CONVERSION_DATE
, MC.RATE_TYPE
, MC.EXCHANGE_RATE
, MC.RAW_COST
, MC.BURDENED_COST
, PA1.ACCT_EXCHANGE_ROUNDING_LIMIT
, PA1.PROJECT_CURRENCY_CODE
, PA1.PROJECT_RATE_DATE
, PA1.PROJECT_RATE_TYPE
, PA1.PROJECT_EXCHANGE_RATE
, PA1.ORIG_EXP_TXN_REFERENCE1
, PA1.ORIG_USER_EXP_TXN_REFERENCE
, PA1.VENDOR_NUMBER
, PA1.ORIG_EXP_TXN_REFERENCE2
, PA1.ORIG_EXP_TXN_REFERENCE3
, PA1.OVERRIDE_TO_ORGANIZATION_NAME
, PA1.REVERSED_ORIG_TXN_REFERENCE
, PA1.BILLABLE_FLAG
, PA1.CREATED_BY
, PA1.CREATION_DATE
, PA1.LAST_UPDATED_BY
, PA1.LAST_UPDATE_DATE
, PA1.PERSON_BUSINESS_GROUP_NAME
, PA1.PROJFUNC_CURRENCY_CODE
, PA1.PROJFUNC_COST_RATE_TYPE
, PA1.PROJFUNC_COST_RATE_DATE
, PA1.PROJFUNC_COST_EXCHANGE_RATE
, PA1.PROJECT_RAW_COST
, PA1.PROJECT_BURDENED_COST
, PA1.ASSIGNMENT_NAME
, PA1.WORK_TYPE_NAME
, PA1.CDL_SYSTEM_REFERENCE4
, PA1.ACCRUAL_FLAG
, PA1.PROJECT_ID
, PA1.TASK_ID
, PA1.PERSON_ID
, PA1.ORGANIZATION_ID
, PA1.NON_LABOR_RESOURCE_ORG_ID
, PA1.VENDOR_ID
, PA1.OVERRIDE_TO_ORGANIZATION_ID
, PA1.ASSIGNMENT_ID
, PA1.WORK_TYPE_ID
, PA1.PERSON_BUSINESS_GROUP_ID
, PA1.INVENTORY_ITEM_ID
, PA1.WIP_RESOURCE_ID
, PA1.UNIT_OF_MEASURE
, PA1.PO_NUMBER
, PA1.PO_HEADER_ID
, PA1.PO_LINE_NUM
, PA1.PO_LINE_ID
, PA1.PERSON_TYPE
, PA1.PO_PRICE_TYPE
, PA1.CDL_SYSTEM_REFERENCE5
, PA1.ADJUSTED_EXPENDITURE_ITEM_ID
, PA1.FC_DOCUMENT_TYPE
, PA1.DOCUMENT_TYPE
, PA1.DOCUMENT_DISTRIBUTION_TYPE
, PA1.SI_ASSETS_ADDITION_FLAG
, PA1.SC_XFER_CODE
FROM PA_TRANSACTION_INTERFACE_ALL PA1
, PA_MC_TXN_INTERFACE_ALL MC
WHERE PA1.TXN_INTERFACE_ID = MC.TXN_INTERFACE_ID
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)