[Home] [Help] [Dependency Information]
Object Name: | IGC_CC_HEADERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGC |
Subobject Name: | |
Status: | VALID |
IGC_CC_HEADERS stores general information about the financial representation of a contract. For each parent contract and release contract, one row will be in this table. Each row contains information specific to the contract, such as the vendor, description, start and end dates, owner, preparer, Set of Books, or approval status. 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. If this is a release contract, the contract will be related to a parent contract. The PARENT_HEADER_ID forms the relationship between the parent contract commitment and the release contract commitment.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGC_CC_HEADERS_A_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CC_HEADER_ID |
IGC_CC_HEADERS_A_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORG_ID
CC_NUM |
IGC_CC_HEADERS_A_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Yes | Contract commitment defining column | |
ORG_ID | NUMBER | (15) | Yes | Organization identifier |
CC_TYPE | VARCHAR2 | (1) | Yes | Type of contract commitment |
CC_NUM | VARCHAR2 | (20) | Yes | Contract commitment number |
CC_REF_NUM | VARCHAR2 | (240) | Reference Number | |
CC_VERSION_NUM | NUMBER | Yes | Contract commitment version number | |
PARENT_HEADER_ID | NUMBER | Contract commitment defining column for the parent contract | ||
CC_STATE | VARCHAR2 | (2) | Yes | State of the contract |
CC_CTRL_STATUS | VARCHAR2 | (1) | Yes | Control status of contract commitment |
CC_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status of contract commitment | |
CC_APPRVL_STATUS | VARCHAR2 | (2) | Yes | Approval status of contract commitment |
VENDOR_ID | NUMBER | Supplier unique identifier | ||
VENDOR_SITE_ID | NUMBER | Supplier site unique identifier | ||
VENDOR_CONTACT_ID | NUMBER | Supplier contact unique identifier | ||
TERM_ID | NUMBER | (15) | Payment terms unique identifier | |
LOCATION_ID | NUMBER | (15) | Ship to location unique identifier | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Accounting books defining column |
CC_ACCT_DATE | DATE | Date of last commitment budget encumbrance | ||
CC_DESC | VARCHAR2 | (240) | Description of contract | |
CC_START_DATE | DATE | Start date of contract | ||
CC_END_DATE | DATE | End date of contract | ||
CC_OWNER_USER_ID | NUMBER | (15) | Yes | User identifier of contract owner |
CC_PREPARER_USER_ID | NUMBER | (15) | Yes | User identifier of contract preparer |
CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier for the entered currency of the contract | |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting the entered currency to the functional currency | |
CONVERSION_DATE | DATE | Conversion date used for converting the entered currency to the functional currency | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the entered currency to the functional currency | ||
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). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
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. | |
CC_CURRENT_USER_ID | NUMBER | (15) | User identifier of individual who has control of the contract for approval purposes | |
WF_ITEM_TYPE | VARCHAR2 | (8) | Workflow approval item type | |
WF_ITEM_KEY | VARCHAR2 | (240) | Workflow approval item key | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CC_GUARANTEE_FLAG | VARCHAR2 | (1) | Flag to indicate whether the Contract Commitment is a Guarantee Commitment. |
Cut, paste (and edit) the following text to query this object:
SELECT CC_HEADER_ID
, ORG_ID
, CC_TYPE
, CC_NUM
, CC_REF_NUM
, CC_VERSION_NUM
, PARENT_HEADER_ID
, CC_STATE
, CC_CTRL_STATUS
, CC_ENCMBRNC_STATUS
, CC_APPRVL_STATUS
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, TERM_ID
, LOCATION_ID
, SET_OF_BOOKS_ID
, CC_ACCT_DATE
, CC_DESC
, CC_START_DATE
, CC_END_DATE
, CC_OWNER_USER_ID
, CC_PREPARER_USER_ID
, CURRENCY_CODE
, CONVERSION_TYPE
, CONVERSION_DATE
, CONVERSION_RATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, CC_CURRENT_USER_ID
, WF_ITEM_TYPE
, WF_ITEM_KEY
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CC_GUARANTEE_FLAG
FROM IGC.IGC_CC_HEADERS_ALL;
IGC.IGC_CC_HEADERS_ALL does not reference any database object
IGC.IGC_CC_HEADERS_ALL is referenced by following:
|
|
|