[Home] [Help]
[Dependency Information]
| Object Name: | PA_EXPEND_ITEMS_ADJUST_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PA.PA_EXPEND_ITEMS_ADJUST_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
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
, DOCUMENT_HEADER_ID
, DOCUMENT_LINE_NUMBER
, DOCUMENT_DISTRIBUTION_ID
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, DOCUMENT_PAYMENT_ID
, RATE_SOURCE_CODE
, RATE_SOURCE_M
, COSTING_METHOD
, COSTING_METHOD_M
, PAYROLL_ACCRUAL_FLAG
, COSTED_PAYROLL_SET_ID
, PAYROLL_NAME
, PAY_PERIOD_START_DATE
, PAY_PERIOD_END_DATE
, CBS_ELEMENT_ID
, COST_CODE
, COST_CODE_NAME
FROM APPS.PA_EXPEND_ITEMS_ADJUST_V;
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
PAY_PAYROLLS_F
PA_CONVERSION_TYPES_V
PA_COST_DIST_LINES_ALL_BAS
PA_EXPENDITURES_ALL
PA_EXPENDITURE_COMMENTS
PA_EXPENDITURE_ITEMS_ALL
PA_EXPENDITURE_TYPES
PA_LOOKUPS
PA_PAY_AUDIT_ALL
PA_PAY_EXTERNAL_PAYROLL
PA_PROJECTS_ALL
PA_PROJECT_TYPES
PA_RBS_ELEMENTS
PA_SYSTEM_LINKAGES
PA_TASKS
PA_TRANSACTION_SOURCES
PER_JOBS
PER_PEOPLE_F
PO_VENDORS
APPS
PA_ASSET_LINE_DETAILS_V
PA_CUST_REV_DIST_LINES_V
PA_DRAFT_INV_LINE_DETAILS_V
|
|
|
|