[Home] [Help] [Dependency Information]
Object Name: | OKL_VP_AGREEMENT_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_VP_AGREEMENT_UV |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column. | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract (RFP,Proposal etc.) Legal Identifier. |
AUTHORING_ORG_ID | NUMBER | Yes | Identifier of the Operating Unit to which the contract belongs. This is the same as that of the responsibility in case the contract is created manually. If the contract is created from another contract (for example, through a copy operation), then this is the same as that of the source contract | |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | A unique internal name for the contract number. | |
CHR_ID_RESPONSE | NUMBER | Surrogate key used for primary unique identifiers. | ||
CHR_ID_AWARD | NUMBER | Surrogate key used for primary unique identifiers. | ||
CHR_ID_RENEWED | NUMBER | ID of the contract from which this contract header was renewed. This column is kept for backward compatibility and will be removed in future releases.. | ||
INV_ORGANIZATION_ID | NUMBER | Yes | Foreign key to MTL_SYSTEM_ITEMS. | |
STS_CODE | VARCHAR2 | (30) | Yes | Status of Contraact Header. |
QCL_ID | NUMBER | ID of QA check list applicable to this contract. | ||
SCS_CODE | VARCHAR2 | (30) | Yes | Contract''s subclass. |
TRN_CODE | VARCHAR2 | (30) | Termination code. | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code as defined in FND_CURRENCIES. | |
ARCHIVED_YN | VARCHAR2 | (3) | Yes | Indicates if this contract is Archived. |
DELETED_YN | VARCHAR2 | (3) | Yes | Indicates if the contract has been SOFT deleted. Future use column. |
TEMPLATE_YN | VARCHAR2 | (3) | Yes | Indicates if this contract is a Template. |
CHR_TYPE | VARCHAR2 | (30) | Yes | Character type. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (3) | Indicates if a Purchase Order is required. | |
PRE_PAY_REQ_YN | VARCHAR2 | (3) | Indicates if Contract pre-payment required . | |
CUST_PO_NUMBER | VARCHAR2 | (150) | Customer''s Purchase Order Number. | |
DPAS_RATING | VARCHAR2 | (24) | DPAS rating. | |
TEMPLATE_USED | VARCHAR2 | (120) | Denotes if a template was used to create contract. | |
DATE_APPROVED | DATE | Date contract was approved. | ||
DATETIME_CANCELLED | DATE | Date / Time Contract was cancelled. | ||
AUTO_RENEW_DAYS | NUMBER | (4) | Number of days prior to expiration before which the contract is automatically renewed. | |
DATE_ISSUED | DATE | Date contract Issued. | ||
DATETIME_RESPONDED | DATE | Date / time response sent. | ||
RFP_TYPE | VARCHAR2 | (30) | RFP Type. | |
KEEP_ON_MAIL_LIST | VARCHAR2 | (3) | Keep us on the mailing list? | |
SET_ASIDE_PERCENT | NUMBER | (5) | Percent set aside for reason specified. | |
RESPONSE_COPIES_REQ | NUMBER | (2) | Number of proposal copies required. | |
DATE_CLOSE_PROJECTED | DATE | Date that contract is expected to be signed. | ||
DATETIME_PROPOSED | DATE | Date / time proposal sent. | ||
DATE_SIGNED | DATE | Date contract was signed. | ||
DATE_TERMINATED | DATE | Date contract terminated. | ||
DATE_RENEWED | DATE | Date contract was renewed. | ||
START_DATE | DATE | The beginning of the active period, one second after midnight on the date indicated. | ||
END_DATE | DATE | The end of the active period, one second before midnight on the date indicated. | ||
BUY_OR_SELL | VARCHAR2 | (3) | Intent of the contract, Buy or Sell. | |
ISSUE_OR_RECEIVE | VARCHAR2 | (3) | Issue or Receive. | |
ESTIMATED_AMOUNT | NUMBER | Estimated amount of contract. | ||
CHR_ID_RENEWED_TO | NUMBER | Indicates the contract header that is the renewal of this contract header. Only present in renewed contracts. This column is kept for backward compatibility and will be removed in future releases. | ||
ESTIMATED_AMOUNT_RENEWED | NUMBER | The estimated amount of the contract of which this contract is a renewal. Only present in renewal contracts. | ||
CURRENCY_CODE_RENEWED | VARCHAR2 | (15) | Currency code from FND_CURRENCIES. The currency for the contract of which this contract is a renewal. Only present in renewal contracts. | |
UPG_ORIG_SYSTEM_REF | VARCHAR2 | (60) | Identifies original source of data | |
UPG_ORIG_SYSTEM_REF_ID | NUMBER | Unique Id from original system | ||
APPLICATION_ID | NUMBER | Identifier of the Oracle application to which the contract belongs. This is same as the application of the class to which the contract belongs | ||
RESOLVED_UNTIL | DATE | Date till which time-values have been resolved for long contracts. | ||
ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | Identifier of the source system | |
ORIG_SYSTEM_ID1 | NUMBER | Unique identifier in the source system | ||
ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Unique identifier in the source system | |
PROGRAM_APPLICATION_ID | NUMBER | Standard Who Column | ||
PROGRAM_ID | NUMBER | Standard Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
REQUEST_ID | NUMBER | Standard Who Column | ||
PRICE_LIST_ID | NUMBER | Identifier of the Price List used for pricing this Contract. Quickcodes : LIST_HEADER_ID from QP_LIST_HEADERS_B | ||
PRICING_DATE | DATE | Effective date used for pricing this Contract | ||
TOTAL_LINE_LIST_PRICE | NUMBER | Sum of the list price of all the priced lines in the Contract. | ||
SIGN_BY_DATE | DATE | Date by which the Contract must be signed. | ||
USER_ESTIMATED_AMOUNT | NUMBER | |||
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description. | |
COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
DESCRIPTION | VARCHAR2 | (1995) | User entered free format text description. | |
COGNOMEN | VARCHAR2 | (300) | Cognomen field. | |
NON_RESPONSE_REASON | VARCHAR2 | (3) | Used with contract RFP. | |
NON_RESPONSE_EXPLAIN | VARCHAR2 | (1995) | Used with contract RFP. | |
SET_ASIDE_REASON | VARCHAR2 | (3) | Used with contract RFP. | |
VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
USER_ACCESS_LEVEL | VARCHAR2 | (0) | ||
PDF_ID | NUMBER | |||
CATEGORY | VARCHAR2 | (90) | ||
STATUS | VARCHAR2 | (90) | ||
STE_CODE | VARCHAR2 | (30) | ||
CHR_ID_REFERRED | NUMBER | |||
PARENT_CONTRACT_NUMBER | VARCHAR2 | (120) | ||
QA_CHECK_NAME | VARCHAR2 | (600) | ||
WORKFLOW_NAME | VARCHAR2 | (1995) | ||
TERMINATION_REASON | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CONTRACT_NUMBER
, AUTHORING_ORG_ID
, CONTRACT_NUMBER_MODIFIER
, CHR_ID_RESPONSE
, CHR_ID_AWARD
, CHR_ID_RENEWED
, INV_ORGANIZATION_ID
, STS_CODE
, QCL_ID
, SCS_CODE
, TRN_CODE
, CURRENCY_CODE
, ARCHIVED_YN
, DELETED_YN
, TEMPLATE_YN
, CHR_TYPE
, OBJECT_VERSION_NUMBER
, CUST_PO_NUMBER_REQ_YN
, PRE_PAY_REQ_YN
, CUST_PO_NUMBER
, DPAS_RATING
, TEMPLATE_USED
, DATE_APPROVED
, DATETIME_CANCELLED
, AUTO_RENEW_DAYS
, DATE_ISSUED
, DATETIME_RESPONDED
, RFP_TYPE
, KEEP_ON_MAIL_LIST
, SET_ASIDE_PERCENT
, RESPONSE_COPIES_REQ
, DATE_CLOSE_PROJECTED
, DATETIME_PROPOSED
, DATE_SIGNED
, DATE_TERMINATED
, DATE_RENEWED
, START_DATE
, END_DATE
, BUY_OR_SELL
, ISSUE_OR_RECEIVE
, ESTIMATED_AMOUNT
, CHR_ID_RENEWED_TO
, ESTIMATED_AMOUNT_RENEWED
, CURRENCY_CODE_RENEWED
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, APPLICATION_ID
, RESOLVED_UNTIL
, ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PRICE_LIST_ID
, PRICING_DATE
, TOTAL_LINE_LIST_PRICE
, SIGN_BY_DATE
, USER_ESTIMATED_AMOUNT
, SHORT_DESCRIPTION
, COMMENTS
, DESCRIPTION
, COGNOMEN
, NON_RESPONSE_REASON
, NON_RESPONSE_EXPLAIN
, SET_ASIDE_REASON
, VENDOR_NAME
, USER_ACCESS_LEVEL
, PDF_ID
, CATEGORY
, STATUS
, STE_CODE
, CHR_ID_REFERRED
, PARENT_CONTRACT_NUMBER
, QA_CHECK_NAME
, WORKFLOW_NAME
, TERMINATION_REASON
FROM APPS.OKL_VP_AGREEMENT_UV;
APPS.OKL_VP_AGREEMENT_UV is not referenced by any database object
|
|
|