[Home] [Help] [Dependency Information]

VIEW: APPS.GMS_EXPEND_ITEMS_ADJUST_V

Object Details

Object Name:	GMS_EXPEND_ITEMS_ADJUST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMS.GMS_EXPEND_ITEMS_ADJUST_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ID
,      ADL_LINE_NUM
,      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
,      ADL_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
FROM APPS.GMS_EXPEND_ITEMS_ADJUST_V;

Dependencies

[top of page]

APPS

FND_LOOKUP_VALUES

GMS_AWARD_DISTRIBUTIONS

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

PA_PROJECT_TYPES_ALL

PA_SYSTEM_LINKAGES

PA_TASKS

PA_TRANSACTION_SOURCES

PER_JOBS

PER_PEOPLE_F

PO_VENDORS

APPS.GMS_EXPEND_ITEMS_ADJUST_V is not referenced by any database object