[Home] [Help] [Dependency Information]

VIEW: APPS.PA_EXPENDITURE_ITEMS_ALL_MRC_V

Object Details

Object Name:	PA_EXPENDITURE_ITEMS_ALL_MRC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_EXPENDITURE_ITEMS_ALL_MRC_V
Subobject Name:
Status:	VALID

View Type

A multiple reporting currency view

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      RAW_COST
,      RAW_COST_RATE
,      BURDEN_COST
,      BURDEN_COST_RATE
,      RAW_REVENUE
,      BILL_RATE
,      ACCRUED_REVENUE
,      ACCRUAL_RATE
,      ADJUSTED_REVENUE
,      ADJUSTED_RATE
,      BILL_AMOUNT
,      PROJFUNC_BILL_AMOUNT
,      BILL_TRANS_BILL_AMOUNT
,      PROJECT_BILL_AMOUNT
,      FORECAST_REVENUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      EXPENDITURE_ID
,      TASK_ID
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      COST_DISTRIBUTED_FLAG
,      REVENUE_DISTRIBUTED_FLAG
,      BILLABLE_FLAG
,      BILL_HOLD_FLAG
,      QUANTITY
,      UNIT_OF_MEASURE
,      NON_LABOR_RESOURCE
,      ORGANIZATION_ID
,      JOB_ID
,      OVERRIDE_TO_ORGANIZATION_ID
,      COST_DIST_REJECTION_CODE
,      LABOR_COST_MULTIPLIER_NAME
,      BILL_RATE_MULTIPLIER
,      REV_DIST_REJECTION_CODE
,      EVENT_NUM
,      EVENT_TASK_ID
,      BILL_JOB_ID
,      BILL_JOB_BILLING_TITLE
,      BILL_EMPLOYEE_BILLING_TITLE
,      ADJUSTED_EXPENDITURE_ITEM_ID
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_EXP_ITEM_ID
,      CONVERTED_FLAG
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      COST_IND_COMPILED_SET_ID
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      COST_BURDEN_DISTRIBUTED_FLAG
,      IND_COST_DIST_REJECTION_CODE
,      ORIG_TRANSACTION_REFERENCE
,      TRANSACTION_SOURCE
,      PROJECT_ID
,      SOURCE_EXPENDITURE_ITEM_ID
,      ORG_ID
,      SYSTEM_LINKAGE_FUNCTION
,      BURDEN_SUM_DEST_RUN_ID
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_EXCHANGE_RATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      ACCT_CURRENCY_CODE
,      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
,      DENORM_ID
,      CC_PRVDR_ORGANIZATION_ID
,      CC_RECVR_ORGANIZATION_ID
,      RECVR_ORG_ID
,      CC_CROSS_CHARGE_CODE
,      CC_CROSS_CHARGE_TYPE
,      CC_REJECTION_CODE
,      CC_BL_DISTRIBUTED_CODE
,      CC_IC_PROCESSED_CODE
,      DENOM_TP_CURRENCY_CODE
,      DENOM_TRANSFER_PRICE
,      ACCT_TP_RATE_TYPE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_EXCHANGE_RATE
,      ACCT_TRANSFER_PRICE
,      PROJACCT_TRANSFER_PRICE
,      CC_MARKUP_BASE_CODE
,      TP_BASE_AMOUNT
,      TP_IND_COMPILED_SET_ID
,      TP_BILL_RATE
,      TP_BILL_MARKUP_PERCENTAGE
,      TP_SCHEDULE_LINE_PERCENTAGE
,      TP_RULE_PERCENTAGE
,      CC_PRVDR_COST_RECLASS_CODE
,      COST_JOB_ID
,      TP_JOB_ID
,      PROV_PROJ_BILL_JOB_ID
,      BILL_TRANS_FORECAST_CURR_CODE
,      BILL_TRANS_FORECAST_REVENUE
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_RAW_REVENUE
,      BILL_TRANS_ADJUSTED_REVENUE
,      REVPROC_CURRENCY_CODE
,      REVPROC_RATE_TYPE
,      REVPROC_RATE_DATE
,      REVPROC_EXCHANGE_RATE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      DISCOUNT_PERCENTAGE
,      INV_GEN_REJECTION_CODE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RAW_REVENUE
,      PROJECT_RAW_REVENUE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      ASSIGNMENT_ID
,      WORK_TYPE_ID
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJECT_TRANSFER_PRICE
,      TP_AMT_TYPE_CODE
,      PROJFUNC_TP_RATE_DATE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_EXCHANGE_RATE
,      PROJFUNC_TRANSFER_PRICE
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_TYPE
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_INV_RATE_TYPE
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      PROJECT_INV_RATE_TYPE
,      PROJECT_INV_RATE_DATE
,      PROJECT_INV_EXCHANGE_RATE
,      PROJFUNC_FCST_RATE_TYPE
,      PROJFUNC_FCST_RATE_DATE
,      PROJFUNC_FCST_EXCHANGE_RATE
,      PRVDR_ACCRUAL_DATE
,      RECVR_ACCRUAL_DATE
,      RATE_DISC_REASON_CODE
,      CAPITAL_EVENT_ID
,      POSTED_DENOM_BURDENED_COST
,      POSTED_PROJECT_BURDENED_COST
,      POSTED_PROJFUNC_BURDENED_COST
,      POSTED_ACCT_BURDENED_COST
,      ADJUSTMENT_TYPE
,      PO_LINE_ID
,      PO_PRICE_TYPE
,      INVENTORY_ITEM_ID
,      WIP_RESOURCE_ID
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_PAYMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      VENDOR_ID
,      HISTORICAL_FLAG
FROM APPS.PA_EXPENDITURE_ITEMS_ALL_MRC_V;

Dependencies

[top of page]

APPS

PA_EXPENDITURE_ITEMS_ALL

PA_MC_EXP_ITEMS_ALL

APPS

PA_AEL_GL_DR_MRC_V

PA_AEL_SL_DR_MRC_V

PA_AEL_SL_EI_MRC_V