[Home] [Help] [Dependency Information]

VIEW: APPS.GMS_COMMITMENTS_OVERRIDE_V

Object Details

Object Name:	GMS_COMMITMENTS_OVERRIDE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMS.GMS_COMMITMENTS_OVERRIDE_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 PROJECT_ID
,      TASK_ID
,      TRANSACTION_SOURCE
,      LINE_TYPE
,      CMT_NUMBER
,      CMT_DISTRIBUTION_ID
,      CMT_HEADER_ID
,      DESCRIPTION
,      EXPENDITURE_ITEM_DATE
,      PA_PERIOD
,      GL_PERIOD
,      CMT_LINE_NUMBER
,      CMT_CREATION_DATE
,      CMT_APPROVED_DATE
,      CMT_REQUESTOR_NAME
,      CMT_BUYER_NAME
,      CMT_APPROVED_FLAG
,      CMT_PROMISED_DATE
,      CMT_NEED_BY_DATE
,      ORGANIZATION_ID
,      VENDOR_ID
,      VENDOR_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      SYSTEM_LINKAGE_FUNCTION
,      UNIT_OF_MEASURE
,      UNIT_PRICE
,      CMT_IND_COMPILED_SET_ID
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      BURDENABLE_RAW_COST
,      TOT_CMT_QUANTITY
,      QUANTITY_ORDERED
,      AMOUNT_ORDERED
,      ORIGINAL_QUANTITY_ORDERED
,      ORIGINAL_AMOUNT_ORDERED
,      QUANTITY_CANCELLED
,      AMOUNT_CANCELLED
,      QUANTITY_DELIVERED
,      QUANTITY_INVOICED
,      AMOUNT_INVOICED
,      QUANTITY_OUTSTANDING_DELIVERY
,      AMOUNT_OUTSTANDING_DELIVERY
,      QUANTITY_OUTSTANDING_INVOICE
,      AMOUNT_OUTSTANDING_INVOICE
,      QUANTITY_OVERBILLED
,      AMOUNT_OVERBILLED
,      ORIGINAL_TXN_REFERENCE1
,      ORIGINAL_TXN_REFERENCE2
,      ORIGINAL_TXN_REFERENCE3
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_EXCHANGE_RATE
FROM APPS.GMS_COMMITMENTS_OVERRIDE_V;

Dependencies

[top of page]

APPS

AP_INVOICES_PKG - show dependent code

CST_PROJMFG_CMT_VIEW

GMS_COST_PLUS_EXTN - show dependent code

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PA_ACCUM_UTILS - show dependent code

PA_BURDEN_CMTS - show dependent code

PA_CMT_UTILS - show dependent code

PA_CURRENCY - show dependent code

PA_MULTI_CURRENCY - show dependent code

PA_PJC_CWK_UTILS - show dependent code

PA_PROJ_AP_INV_DISTRIBUTIONS

PA_PROJ_PO_DISTRIBUTIONS

PA_PROJ_REQ_DISTRIBUTIONS

PJM_PO_COMMITMENTS_V

PJM_REQ_COMMITMENTS_V

APPS

GMS_COMMITMENT_TXNS_V