DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.GMS_COMMITMENT_ENCUMBERED_V

Object Details
Object Name: GMS_COMMITMENT_ENCUMBERED_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMS.GMS_COMMITMENT_ENCUMBERED_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
Name Datatype Length Mandatory Comments
DOCUMENT_TYPE VARCHAR2 (3)
TRANSACTION_SOURCE VARCHAR2 (80)
CMT_NUMBER VARCHAR2 (50)
DESCRIPTION VARCHAR2 (240)
PROJECT_ID NUMBER

TASK_ID NUMBER

AWARD_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

ORGANIZATION_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
UNIT_OF_MEASURE VARCHAR2 (25)
UNIT_PRICE NUMBER

TOT_CMT_QUANTITY NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

IND_COMPILED_SET_ID NUMBER (15)
BURDENABLE_RAW_COST NUMBER

PA_PERIOD VARCHAR2 (20)
GL_DATE DATE

Query Text

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


SELECT DOCUMENT_TYPE
,      TRANSACTION_SOURCE
,      CMT_NUMBER
,      DESCRIPTION
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      ORGANIZATION_ID
,      VENDOR_NAME
,      UNIT_OF_MEASURE
,      UNIT_PRICE
,      TOT_CMT_QUANTITY
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      IND_COMPILED_SET_ID
,      BURDENABLE_RAW_COST
,      PA_PERIOD
,      GL_DATE
FROM APPS.GMS_COMMITMENT_ENCUMBERED_V;

Dependencies

[top of page]

APPS.GMS_COMMITMENT_ENCUMBERED_V references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
SynonymGL_LEDGERS
SynonymGMS_AWARD_DISTRIBUTIONS
PL/SQL PackageGMS_BUDGET_BALANCE - show dependent code
SynonymGMS_ENCUMBRANCES_ALL
SynonymGMS_ENCUMBRANCE_ITEMS_ALL
PL/SQL PackagePA_CMT_UTILS - show dependent code
SynonymPA_PERIODS
SynonymPA_TRANSACTION_SOURCES
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
PL/SQL PackagePO_INTG_DOCUMENT_FUNDS_GRP - show dependent code
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
ViewPO_VENDORS
APPS.GMS_COMMITMENT_ENCUMBERED_V is referenced by following:

SchemaAPPS
ViewGMS_COMMITMENT_BURDEN_V
Package BodyGMS_WF_PKG - show dependent code