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


VIEW: APPS.IGCFV_CC_RELEASES

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

View Type

A Business Intelligence System view


IGCFV_CC_RELEASES display a contract within a contract such as a release contract commitment within a cover contract commitment, in which the anticipated expenditures amounts must fall within the parent contract commitment.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RELEASE_CONTRACT_NUMBER VARCHAR2 (20) Yes
RELEASE_VERSION_NUMBER NUMBER
Yes
_LA:RELEASE_APPROVAL_STATUS CHAR (71)
_LA:RELEASE_CONTROL_STATUS CHAR (68)
_LA:STATE CHAR (53)
_LA:TYPE CHAR (51)
DESCRIPTION VARCHAR2 (240)
START_EFFECTIVE_DATE DATE

END_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
PARENT_CONTRACT_NUMBER VARCHAR2 (20) 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
PARENT_CONTRACT_COMMITMENT_ID NUMBER

RELEASE_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 RELEASE_CONTRACT_NUMBER
,      RELEASE_VERSION_NUMBER
,      _LA:RELEASE_APPROVAL_STATUS
,      _LA:RELEASE_CONTROL_STATUS
,      _LA:STATE
,      _LA:TYPE
,      DESCRIPTION
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      _DF
,      USER_NAME
,      TERMS_NAME
,      SETS_OF_BOOKS_NAME
,      SETS_OF_BOOKS_SHORT_NAME
,      CONVERSION_USER_TYPES
,      LOCATION_CODE
,      ORGANIZATION_NAME
,      PARENT_CONTRACT_NUMBER
,      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
,      PARENT_CONTRACT_COMMITMENT_ID
,      RELEASE_CONTRACT_COMMITMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGCFV_CC_RELEASES;

Dependencies

[top of page]

APPS.IGCFV_CC_RELEASES references the following:

SchemaAPPS
SynonymAP_TERMS_TL
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_RELEASES is not referenced by any database object