[Home] [Help] [Dependency Information]

VIEW: APPS.PA_EXPEND_ITEMS_ADJUST_ALL_V

Object Details

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_TYPE
,      PROJECT_TYPE_CLASS_CODE
,      PROJECT_CLASS
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY_CODE
,      INCURRED_BY_PERSON_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      JOB_ID
,      JOB_NAME
,      INCURRED_BY_ORGANIZATION_ID
,      OVERRIDE_TO_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      EMPLOYEE_VENDOR_NAME
,      EMPLOYEE_VENDOR_NUMBER
,      NON_LABOR_RESOURCE
,      NLR_ORGANIZATION_ID
,      NLR_ORGANIZATION_NAME
,      SYSTEM_LINKAGE_FUNCTION
,      SYSTEM_LINKAGE_M
,      EXPENDITURE_COMMENT
,      TRANSACTION_SOURCE
,      ORIG_TRANSACTION_REFERENCE
,      EXPENDITURE_GROUP
,      EXPENDITURE_STATUS_CODE
,      EXPENDITURE_STATUS_M
,      EXPENDITURE_ENDING_DATE
,      QUANTITY
,      BURDEN_COST
,      UNIT_OF_MEASURE
,      UNIT_OF_MEASURE_M
,      RAW_COST
,      RAW_COST_RATE
,      COST_DISTRIBUTED_FLAG
,      COST_DIST_REJECTION_CODE
,      LABOR_COST_MULTIPLIER_NAME
,      BURDENED_COST
,      BURDENED_COST_RATE
,      COST_BURDEN_DISTRIBUTED_FLAG
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_EXCHANGE_RATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_TYPE
,      ACCT_RATE_DATE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      IND_COST_DIST_REJECTION_CODE
,      COST_IND_COMPILED_SET_ID
,      CAPITALIZABLE_FLAG
,      ACCRUED_REVENUE
,      ACCRUAL_RATE
,      RAW_REVENUE
,      FORECAST_REVENUE
,      BILL_AMOUNT
,      BILL_RATE
,      BILL_RATE_MULTIPLIER
,      ADJUSTED_REVENUE
,      ADJUSTED_RATE
,      BILLABLE_FLAG
,      REVENUE_DISTRIBUTED_FLAG
,      BILL_HOLD_FLAG
,      REV_DIST_REJECTION_CODE
,      BILL_JOB_ID
,      BILL_JOB_BILLING_TITLE
,      BILL_EMPLOYEE_BILLING_TITLE
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      EVENT_PROJECT_ID
,      EVENT_NUM
,      EVENT_TASK_ID
,      ADJUSTED_EXPENDITURE_ITEM_ID
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_EXP_ITEM_ID
,      CONVERTED_FLAG
,      SOURCE_EXPENDITURE_ITEM_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      EXPENDITURE_ORG_ID
,      SYSTEM_REFERENCE2
,      ORG_ID
,      USER_TRANSACTION_SOURCE
,      ALLOW_ADJUSTMENTS_FLAG
,      COSTED_FLAG
,      COST_BURDENED_FLAG
,      GL_ACCOUNTED_FLAG
,      ALLOW_REVERSAL_FLAG
,      ALLOW_BURDEN_FLAG
,      BURDEN_SUM_DEST_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      BURDEN_SUM_REJECTION_M
,      PROJECT_STATUS_CODE
,      USER_ACCT_RATE_TYPE
,      USER_PROJECT_RATE_TYPE
,      ORIG_EXP_TXN_REFERENCE1
,      ORIG_USER_EXP_TXN_REFERENCE
,      ORIG_EXP_TXN_REFERENCE2
,      ORIG_EXP_TXN_REFERENCE3
,      OVERRIDING_APPROVER_PERSON_ID
,      WF_STATUS_CODE
,      TRANSFER_STATUS_CODE
,      USER_BATCH_NAME
,      BILL_TRANS_CURRENCY_CODE
,      PROJECT_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_BILL_AMOUNT
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      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
,      BILL_TRANS_BILL_AMOUNT
,      PRVDR_ACCRUAL_DATE
,      RECVR_ACCRUAL_DATE
,      CC_CROSS_CHARGE_CODE
,      CC_CROSS_CHARGE_TYPE
,      CC_BL_DISTRIBUTED_CODE
,      CC_IC_PROCESSED_CODE
,      CC_REJECTION_CODE
,      PRVDR_ORG_ID
,      RECVR_ORG_ID
,      ACCT_TP_RATE_TYPE
,      USER_ACCT_TP_RATE_TYPE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_EXCHANGE_RATE
,      USER_PROJFUNC_COST_RATE_TYPE
,      DENOM_TP_CURRENCY_CODE
,      MRC_RAW_REVENUE
,      MRC_BILL_RATE
,      MRC_ACCRUED_REVENUE
,      MRC_ACCRUAL_RATE
,      MRC_ADJUSTED_REVENUE
,      MRC_ADJUSTED_RATE
,      MRC_BILL_AMOUNT
,      MRC_FORECAST_REVENUE
,      MRC_ACCT_CURRENCY_CODE
,      MRC_ACCT_RATE_DATE
,      MRC_ACCT_RATE_TYPE
,      MRC_ACCT_EXCHANGE_RATE
,      MRC_ACCT_RAW_COST
,      MRC_ACCT_BURDENED_COST
,      MRC_REVENUE_RATE_TYPE
,      MRC_REVENUE_CONVERSION_DATE
,      MRC_REVENUE_EXCHANGE_RATE
,      MRC_ACCT_TP_RATE_TYPE
,      MRC_ACCT_TP_RATE_DATE
,      MRC_ACCT_TP_EXCHANGE_RATE
,      MRC_ACCT_TRANSFER_PRICE
,      MRC_PROJFUNC_INV_RATE_TYPE
,      MRC_PROJFUNC_INV_RATE_DATE
,      MRC_PROJFUNC_INV_EXCHANGE_RATE
,      MRC_PROJFUNC_FCST_RATE_TYPE
,      MRC_PROJFUNC_FCST_RATE_DATE
,      MRC_PROJFUNC_FCST_XCHANGE_RATE
FROM APPS.PA_EXPEND_ITEMS_ADJUST_ALL_V;

Dependencies

[top of page]

APPS

FND_LOOKUP_VALUES

HR_ALL_ORGANIZATION_UNITS_TL

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PA_CONVERSION_TYPES_V

PA_COST_DIST_LINES_ALL_BAS

PA_EXPENDITURES_ALL

PA_EXPENDITURE_COMMENTS

PA_EXPENDITURE_ITEMS_ALL

PA_EXPENDITURE_TYPES

PA_PROJECTS_ALL

PA_PROJECT_TYPES_ALL

PA_SYSTEM_LINKAGES

PA_TASKS

PA_TRANSACTION_SOURCES

PER_ALL_PEOPLE_F

PER_JOBS

PER_PEOPLE_F

PO_VENDORS

APPS

PA_INV_LINE_DETAILS_ALL_V