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

VIEW: APPS.IGCFV_CC_ACTION_HISTORIES

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

View Type

A Business Intelligence System view


IGCFV_CC_ACTION_HISTORIES display the series of actions that are initiated against the contract commitment. Actions are created by events that occur in both Contract Commitment system and Workflow subsystem.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTION_NUMBER NUMBER
Yes
_LA:ACTION_TYPE CHAR (57)
_LA:ACTION_STATE CHAR (52)
_LA:ACTION_CONTROL_STATUS CHAR (67)
_LA:ACTION_APPROVAL_STATUS CHAR (70)
ACTION_NOTES VARCHAR2 (240)
CONTRACT_COMMITMENT_NUMBER VARCHAR2 (20) Yes
CONTRACT_VERSION_NUMBER NUMBER
Yes
CONTRACT_COMMITMENT_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT ACTION_NUMBER
,      _LA:ACTION_TYPE
,      _LA:ACTION_STATE
,      _LA:ACTION_CONTROL_STATUS
,      _LA:ACTION_APPROVAL_STATUS
,      ACTION_NOTES
,      CONTRACT_COMMITMENT_NUMBER
,      CONTRACT_VERSION_NUMBER
,      CONTRACT_COMMITMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGCFV_CC_ACTION_HISTORIES;

Dependencies

[top of page]

APPS.IGCFV_CC_ACTION_HISTORIES references the following:

SchemaAPPS
SynonymIGC_CC_ACTIONS
SynonymIGC_CC_HEADERS_ALL

APPS.IGCFV_CC_ACTION_HISTORIES is not referenced by any database object