DBA Data[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: ViewPA.PA_EXPENDITURE_ITEMS_ALL_MRC_V
Subobject Name:
Status: VALID

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
EXPENDITURE_ITEM_ID NUMBER (15) Yes
RAW_COST NUMBER

RAW_COST_RATE NUMBER

BURDEN_COST NUMBER

BURDEN_COST_RATE NUMBER

RAW_REVENUE NUMBER

BILL_RATE NUMBER

ACCRUED_REVENUE NUMBER

ACCRUAL_RATE NUMBER

ADJUSTED_REVENUE NUMBER

ADJUSTED_RATE NUMBER

BILL_AMOUNT NUMBER (22)
PROJFUNC_BILL_AMOUNT NUMBER

BILL_TRANS_BILL_AMOUNT NUMBER

PROJECT_BILL_AMOUNT NUMBER

FORECAST_REVENUE NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
EXPENDITURE_ID NUMBER (15) Yes
TASK_ID NUMBER (15) Yes
EXPENDITURE_ITEM_DATE DATE
Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
COST_DISTRIBUTED_FLAG VARCHAR2 (1) Yes
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1) Yes
BILLABLE_FLAG VARCHAR2 (1) Yes
BILL_HOLD_FLAG VARCHAR2 (1) Yes
QUANTITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
NON_LABOR_RESOURCE VARCHAR2 (20)
ORGANIZATION_ID NUMBER (15)
JOB_ID NUMBER (15)
OVERRIDE_TO_ORGANIZATION_ID NUMBER (15)
COST_DIST_REJECTION_CODE VARCHAR2 (30)
LABOR_COST_MULTIPLIER_NAME VARCHAR2 (20)
BILL_RATE_MULTIPLIER NUMBER (22)
REV_DIST_REJECTION_CODE VARCHAR2 (30)
EVENT_NUM NUMBER (15)
EVENT_TASK_ID NUMBER (15)
BILL_JOB_ID NUMBER (15)
BILL_JOB_BILLING_TITLE VARCHAR2 (80)
BILL_EMPLOYEE_BILLING_TITLE VARCHAR2 (80)
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER (15)
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER (15)
CONVERTED_FLAG VARCHAR2 (1)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
COST_IND_COMPILED_SET_ID NUMBER (15)
REV_IND_COMPILED_SET_ID NUMBER (15)
INV_IND_COMPILED_SET_ID NUMBER (15)
COST_BURDEN_DISTRIBUTED_FLAG VARCHAR2 (1)
IND_COST_DIST_REJECTION_CODE VARCHAR2 (30)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (50)
TRANSACTION_SOURCE VARCHAR2 (30)
PROJECT_ID NUMBER (15)
SOURCE_EXPENDITURE_ITEM_ID NUMBER (15)
ORG_ID NUMBER (15)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Yes
BURDEN_SUM_DEST_RUN_ID NUMBER (15)
RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_EXCHANGE_RATE NUMBER

DENOM_CURRENCY_CODE VARCHAR2 (15)
DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (30)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_EXCHANGE_RATE NUMBER

DENORM_ID NUMBER (15)
CC_PRVDR_ORGANIZATION_ID NUMBER

CC_RECVR_ORGANIZATION_ID NUMBER

RECVR_ORG_ID NUMBER

CC_CROSS_CHARGE_CODE VARCHAR2 (1) Yes
CC_CROSS_CHARGE_TYPE VARCHAR2 (2)
CC_REJECTION_CODE VARCHAR2 (30)
CC_BL_DISTRIBUTED_CODE VARCHAR2 (1) Yes
CC_IC_PROCESSED_CODE VARCHAR2 (1) Yes
DENOM_TP_CURRENCY_CODE VARCHAR2 (15)
DENOM_TRANSFER_PRICE NUMBER

ACCT_TP_RATE_TYPE VARCHAR2 (30)
ACCT_TP_RATE_DATE DATE

ACCT_TP_EXCHANGE_RATE NUMBER

ACCT_TRANSFER_PRICE NUMBER

PROJACCT_TRANSFER_PRICE NUMBER

CC_MARKUP_BASE_CODE VARCHAR2 (1)
TP_BASE_AMOUNT NUMBER

TP_IND_COMPILED_SET_ID NUMBER

TP_BILL_RATE NUMBER

TP_BILL_MARKUP_PERCENTAGE NUMBER

TP_SCHEDULE_LINE_PERCENTAGE NUMBER

TP_RULE_PERCENTAGE NUMBER

CC_PRVDR_COST_RECLASS_CODE VARCHAR2 (1)
COST_JOB_ID NUMBER (15)
TP_JOB_ID NUMBER (15)
PROV_PROJ_BILL_JOB_ID NUMBER (15)
BILL_TRANS_FORECAST_CURR_CODE VARCHAR2 (15)
BILL_TRANS_FORECAST_REVENUE NUMBER

BILL_TRANS_CURRENCY_CODE VARCHAR2 (15)
BILL_TRANS_RAW_REVENUE NUMBER

BILL_TRANS_ADJUSTED_REVENUE NUMBER

REVPROC_CURRENCY_CODE VARCHAR2 (15)
REVPROC_RATE_TYPE VARCHAR2 (30)
REVPROC_RATE_DATE DATE

REVPROC_EXCHANGE_RATE NUMBER

INVPROC_CURRENCY_CODE VARCHAR2 (15)
INVPROC_RATE_TYPE VARCHAR2 (30)
INVPROC_RATE_DATE DATE

INVPROC_EXCHANGE_RATE NUMBER

DISCOUNT_PERCENTAGE NUMBER

INV_GEN_REJECTION_CODE VARCHAR2 (30)
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_RAW_REVENUE NUMBER

PROJECT_RAW_REVENUE NUMBER

PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PROJFUNC_COST_RATE_DATE DATE

PROJFUNC_COST_EXCHANGE_RATE NUMBER

PROJECT_RAW_COST NUMBER

PROJECT_BURDENED_COST NUMBER

ASSIGNMENT_ID NUMBER (15)
WORK_TYPE_ID NUMBER (15)
PROJECT_TP_RATE_DATE DATE

PROJECT_TP_RATE_TYPE VARCHAR2 (30)
PROJECT_TP_EXCHANGE_RATE NUMBER

PROJECT_TRANSFER_PRICE NUMBER

TP_AMT_TYPE_CODE VARCHAR2 (30)
PROJFUNC_TP_RATE_DATE DATE

PROJFUNC_TP_RATE_TYPE VARCHAR2 (30)
PROJFUNC_TP_EXCHANGE_RATE NUMBER

PROJFUNC_TRANSFER_PRICE NUMBER

PROJECT_REV_RATE_TYPE VARCHAR2 (30)
PROJECT_REV_RATE_DATE DATE

PROJECT_REV_EXCHANGE_RATE NUMBER

PROJFUNC_REV_RATE_TYPE VARCHAR2 (30)
PROJFUNC_REV_RATE_DATE DATE

PROJFUNC_REV_EXCHANGE_RATE NUMBER

PROJFUNC_INV_RATE_TYPE VARCHAR2 (30)
PROJFUNC_INV_RATE_DATE DATE

PROJFUNC_INV_EXCHANGE_RATE NUMBER

PROJECT_INV_RATE_TYPE VARCHAR2 (30)
PROJECT_INV_RATE_DATE DATE

PROJECT_INV_EXCHANGE_RATE NUMBER

PROJFUNC_FCST_RATE_TYPE VARCHAR2 (30)
PROJFUNC_FCST_RATE_DATE DATE

PROJFUNC_FCST_EXCHANGE_RATE NUMBER

PRVDR_ACCRUAL_DATE DATE

RECVR_ACCRUAL_DATE DATE

RATE_DISC_REASON_CODE VARCHAR2 (30)
CAPITAL_EVENT_ID NUMBER (15)
POSTED_DENOM_BURDENED_COST NUMBER

POSTED_PROJECT_BURDENED_COST NUMBER

POSTED_PROJFUNC_BURDENED_COST NUMBER

POSTED_ACCT_BURDENED_COST NUMBER

ADJUSTMENT_TYPE VARCHAR2 (150)
PO_LINE_ID NUMBER

PO_PRICE_TYPE VARCHAR2 (30)
INVENTORY_ITEM_ID NUMBER

WIP_RESOURCE_ID NUMBER

DOCUMENT_HEADER_ID NUMBER (15)
DOCUMENT_DISTRIBUTION_ID NUMBER (15)
DOCUMENT_LINE_NUMBER NUMBER (15)
DOCUMENT_PAYMENT_ID NUMBER (15)
DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 (30)
VENDOR_ID NUMBER

HISTORICAL_FLAG VARCHAR2 (1)
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_MRC_V references the following:

SchemaAPPS
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_MC_EXP_ITEMS_ALL
APPS.PA_EXPENDITURE_ITEMS_ALL_MRC_V is referenced by following:

SchemaAPPS
ViewPA_AEL_GL_DR_MRC_V
ViewPA_AEL_SL_DR_MRC_V
ViewPA_AEL_SL_EI_MRC_V