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

VIEW: APPS.GMS_COMMITMENT_BURDEN_V

Object Details
Object Name: GMS_COMMITMENT_BURDEN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMS.GMS_COMMITMENT_BURDEN_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

PA_PERIOD VARCHAR2 (20)
TOT_CMT_QUANTITY NUMBER

quantity for the burden is 0
ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

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
,      PA_PERIOD
,      TOT_CMT_QUANTITY
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      GL_DATE
FROM APPS.GMS_COMMITMENT_BURDEN_V;

Dependencies

[top of page]

APPS.GMS_COMMITMENT_BURDEN_V references the following:

SchemaAPPS
PL/SQL PackageGMS_BUDGET_BALANCE - show dependent code
ViewGMS_COMMITMENT_ENCUMBERED_V
PL/SQL PackagePA_CMT_UTILS - show dependent code
SynonymPA_COMPILED_MULTIPLIERS
SynonymPA_COST_BASE_EXP_TYPES
SynonymPA_IND_COMPILED_SETS
SynonymPA_IND_COST_CODES
SynonymPA_IND_RATE_SCH_REVISIONS
PL/SQL PackagePO_INTG_DOCUMENT_FUNDS_GRP - show dependent code
APPS.GMS_COMMITMENT_BURDEN_V is referenced by following:

SchemaAPPS
ViewGMS_STATUS_COMMITMENTS_V