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


VIEW: APPS.IGCFV_CC_CONTRACT_COMMITMENTS

Object Details
Object Name: IGCFV_CC_CONTRACT_COMMITMENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGC.IGCFV_CC_CONTRACT_COMMITMENTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


IGCFV_CC_CONTRACT_COMMITMENTS displays general information about the financial representation of a contract. A contract commitment can stand alone such as an individual contract commitment, it can be related to another contract commitment such as a cover contract commitment, or it can be consumed by one or more release contract commitments.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_COMMITMENT_NUMBER VARCHAR2 (20) Yes
CONTRACT_VERSION_NUMBER NUMBER
Yes
_LA:APPROVAL_STATUS CHAR (63)
_LA:CONTROL_STATUS CHAR (60)
_LA:ENCUMBRANCE_STATUS CHAR (68)
_LA:STATE CHAR (45)
_LA:TYPE CHAR (43)
DESCRIPTION VARCHAR2 (240)
END_EFFECTIVE_DATE DATE

START_EFFECTIVE_DATE DATE

_DF CHAR (30)
USER_NAME VARCHAR2 (100)
TERMS_NAME VARCHAR2 (50)
SETS_OF_BOOKS_NAME VARCHAR2 (30) Yes
SETS_OF_BOOKS_SHORT_NAME VARCHAR2 (20) Yes
CONVERSION_USER_TYPES VARCHAR2 (30)
LOCATION_CODE VARCHAR2 (60)
ORGANIZATION_NAME VARCHAR2 (240) Yes
VENDOR_NAME VARCHAR2 (240)
VENDORS_NUMBER VARCHAR2 (30)
VENDOR_CONTACTS_LAST_NAME VARCHAR2 (15)
VENDOR_CONTACTS_FIRST_NAME VARCHAR2 (15)
VENDOR_SITES_CODE VARCHAR2 (15)
CURRENCY_CODE VARCHAR2 (15)
CONVERSION_TYPE VARCHAR2 (30)
ORGANIZATION_ID NUMBER (15) Yes
TERM_ID NUMBER (15)
VENDOR_SITE_ID NUMBER

VENDOR_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15) Yes
VENDOR_CONTACT_ID NUMBER

LOCATION_ID NUMBER (15)
OWNER_USER_ID NUMBER (15) Yes
PREPARER_USER_ID NUMBER (15) Yes
CONTRACT_COMMITMENT_ID NUMBER
Yes
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
Query Text

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


SELECT CONTRACT_COMMITMENT_NUMBER
,      CONTRACT_VERSION_NUMBER
,      _LA:APPROVAL_STATUS
,      _LA:CONTROL_STATUS
,      _LA:ENCUMBRANCE_STATUS
,      _LA:STATE
,      _LA:TYPE
,      DESCRIPTION
,      END_EFFECTIVE_DATE
,      START_EFFECTIVE_DATE
,      _DF
,      USER_NAME
,      TERMS_NAME
,      SETS_OF_BOOKS_NAME
,      SETS_OF_BOOKS_SHORT_NAME
,      CONVERSION_USER_TYPES
,      LOCATION_CODE
,      ORGANIZATION_NAME
,      VENDOR_NAME
,      VENDORS_NUMBER
,      VENDOR_CONTACTS_LAST_NAME
,      VENDOR_CONTACTS_FIRST_NAME
,      VENDOR_SITES_CODE
,      CURRENCY_CODE
,      CONVERSION_TYPE
,      ORGANIZATION_ID
,      TERM_ID
,      VENDOR_SITE_ID
,      VENDOR_ID
,      SET_OF_BOOKS_ID
,      VENDOR_CONTACT_ID
,      LOCATION_ID
,      OWNER_USER_ID
,      PREPARER_USER_ID
,      CONTRACT_COMMITMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGCFV_CC_CONTRACT_COMMITMENTS;

Dependencies

[top of page]

APPS.IGCFV_CC_CONTRACT_COMMITMENTS references the following:

SchemaAPPS
SynonymAP_TERMS_TL
SynonymFND_CURRENCIES
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_SETS_OF_BOOKS_11I
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_LOCATIONS_ALL
SynonymIGC_CC_HEADERS_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.IGCFV_CC_CONTRACT_COMMITMENTS is not referenced by any database object