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


VIEW: APPS.IGC_CC_HEADERS_V

Object Details
Object Name: IGC_CC_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGC.IGC_CC_HEADERS_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
ROW_ID ROWID (10)
CC_HEADER_ID NUMBER
Yes
ORG_ID NUMBER (15) Yes Organization identifier
CC_TYPE VARCHAR2 (80)
CC_TYPE_CODE VARCHAR2 (1) Yes
CC_NUM VARCHAR2 (20) Yes Contract commitment number
CC_REF_NUM VARCHAR2 (240)
CC_VERSION_NUM NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15)
CC_STATE VARCHAR2 (80)
CC_STATE_CODE VARCHAR2 (2) Yes
CC_APPRVL_STATUS VARCHAR2 (80)
CC_APPRVL_STATUS_CODE VARCHAR2 (2) Yes
CC_CTRL_STATUS VARCHAR2 (80)
CC_CTRL_STATUS_CODE VARCHAR2 (1) Yes
VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
Supplier number
VENDOR_ID NUMBER

VENDOR_SITE_CODE VARCHAR2 (15)
VENDOR_SITE_ID NUMBER

VENDOR_CONTACT VARCHAR2 (31)
VENDOR_CONTACT_ID NUMBER

CC_PREPARER_USER_NAME VARCHAR2 (100)
CC_PREPARER_USER_ID NUMBER (15) Yes
CC_PREPARER_EMP_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by and who is cc preparer employee name
CC_PREPARER_EMP_ID NUMBER (15)
System generated person primary key from PER_PEOPLE_S for Cc Preparer Employee Id.
CC_OWNER_USER_NAME VARCHAR2 (100)
CC_OWNER_USER_ID NUMBER (15) Yes
CC_OWNER_EMP_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by and who is cc owner employee name.
CC_OWNER_EMP_ID NUMBER (15)
System generated person primary key from PER_PEOPLE_S for Cc Owner Employee Id.
TERM_NAME VARCHAR2 (50)
TERM_ID NUMBER (15)
BILL_TO_LOCATION VARCHAR2 (60)
BILL_TO_LOCATION_ID NUMBER (15)
Bill-to location unique identifier
CC_DESC VARCHAR2 (240)
CC_ACCT_DATE DATE

CC_START_DATE DATE

CC_END_DATE DATE

CONVERSION_TYPE VARCHAR2 (30)
CONVERSION_DATE DATE

CONVERSION_RATE NUMBER

PARENT_CC_HEADER_ID NUMBER

CC_ENCMBRNC_STATUS VARCHAR2 (80)
CC_ENCMBRNC_STATUS_CODE VARCHAR2 (1)
SET_OF_BOOKS_ID NUMBER (15) Yes
PARENT_CC_NUM VARCHAR2 (20)
Contract commitment number
HOLD_FLAG VARCHAR2 (1)
Indicator of whether the supplier is on purchasing hold
CC_CURRENT_USER_NAME VARCHAR2 (100)
Application username (what a user types in at the Oracle Applications sign-on screen)
CC_CURRENT_USER_ID NUMBER (15)
ACCESS_LEVEL VARCHAR2 (1)
Application username (what a user types in at the Oracle Applications sign-on screen)
WF_ITEM_TYPE VARCHAR2 (8)
WF_ITEM_KEY VARCHAR2 (240)
CONTEXT VARCHAR2 (30)
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
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.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CC_GUARANTEE_FLAG VARCHAR2 (1)
Indicates whether the contract commitment is a Guarantee Commitment.
Query Text

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


SELECT ROW_ID
,      CC_HEADER_ID
,      ORG_ID
,      CC_TYPE
,      CC_TYPE_CODE
,      CC_NUM
,      CC_REF_NUM
,      CC_VERSION_NUM
,      CURRENCY_CODE
,      CC_STATE
,      CC_STATE_CODE
,      CC_APPRVL_STATUS
,      CC_APPRVL_STATUS_CODE
,      CC_CTRL_STATUS
,      CC_CTRL_STATUS_CODE
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      VENDOR_CONTACT
,      VENDOR_CONTACT_ID
,      CC_PREPARER_USER_NAME
,      CC_PREPARER_USER_ID
,      CC_PREPARER_EMP_NAME
,      CC_PREPARER_EMP_ID
,      CC_OWNER_USER_NAME
,      CC_OWNER_USER_ID
,      CC_OWNER_EMP_NAME
,      CC_OWNER_EMP_ID
,      TERM_NAME
,      TERM_ID
,      BILL_TO_LOCATION
,      BILL_TO_LOCATION_ID
,      CC_DESC
,      CC_ACCT_DATE
,      CC_START_DATE
,      CC_END_DATE
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      PARENT_CC_HEADER_ID
,      CC_ENCMBRNC_STATUS
,      CC_ENCMBRNC_STATUS_CODE
,      SET_OF_BOOKS_ID
,      PARENT_CC_NUM
,      HOLD_FLAG
,      CC_CURRENT_USER_NAME
,      CC_CURRENT_USER_ID
,      ACCESS_LEVEL
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CC_GUARANTEE_FLAG
FROM APPS.IGC_CC_HEADERS_V;

Dependencies

[top of page]

APPS.IGC_CC_HEADERS_V references the following:

SchemaAPPS
SynonymAP_TERMS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymFND_USER
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageIGC_CC_ACCESS_PKG - show dependent code
SynonymIGC_CC_HEADERS
SynonymIGC_CC_HEADERS_ALL
ViewPER_ASSIGNMENTS_F
SynonymPER_ASSIGNMENT_STATUS_TYPES
ViewPER_PEOPLE_F
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.IGC_CC_HEADERS_V is not referenced by any database object