[Home] [Help] [Dependency Information]
Object Name: | OKL_AM_CONTRACT_PARTIES_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_AM_CONTRACT_PARTIES_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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
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 | Surrogate key used for primary unique identifiers. | ||
INV_ORGANIZATION_ID | NUMBER | Yes | Foreign key to MTL_SYSTEM_ITEMS. | |
STS_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
STS_MEANING | VARCHAR2 | (90) | Yes | |
STE_CODE | VARCHAR2 | (30) | Yes | |
QCL_ID | NUMBER | Foreign key to OKC_QA_CHECK_LISTS_B. | ||
SCS_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_LOOKUP_VALUES. |
SCS_MEANING | VARCHAR2 | (90) | Yes | |
RLE_CODE | VARCHAR2 | (30) | Yes | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | A unique internal name for the contract number. | |
ARCHIVED_YN | VARCHAR2 | (3) | Yes | Lookup type for Yes/No columns |
DELETED_YN | VARCHAR2 | (3) | Yes | Lookup type for Yes/No columns |
CUST_PO_NUMBER_REQ_YN | VARCHAR2 | (3) | Purchase Order required flag. | |
PRE_PAY_REQ_YN | VARCHAR2 | (3) | Contract pre-payment required flag. | |
CUST_PO_NUMBER | VARCHAR2 | (150) | Customer's Purchase Order Number. | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description. | |
COMMENTS | VARCHAR2 | (1995) | User entered comments | |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
DPAS_RATING | VARCHAR2 | (24) | DPAS rating. | |
COGNOMEN | VARCHAR2 | (300) | Cognomen field. | |
TEMPLATE_YN | VARCHAR2 | (3) | Yes | Yes or No Flag. |
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 before automatic renewal of contract. | |
DATE_ISSUED | DATE | Date contract Issued. | ||
DATETIME_RESPONDED | DATE | Date / time response sent. | ||
NON_RESPONSE_REASON | VARCHAR2 | (3) | Used with contract RFP. | |
NON_RESPONSE_EXPLAIN | VARCHAR2 | (1995) | Used with contract RFP. | |
RFP_TYPE | VARCHAR2 | (30) | RFP Type. | |
CHR_TYPE | VARCHAR2 | (30) | Yes | Character type. |
KEEP_ON_MAIL_LIST | VARCHAR2 | (3) | Keep us on the mailing list? | |
SET_ASIDE_REASON | VARCHAR2 | (3) | Used with contract RFP. | |
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. | ||
TRN_CODE | VARCHAR2 | (30) | Termination code. | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
AUTHORING_ORG_ID | NUMBER | Yes | Authoring Organization ID. | |
BUY_OR_SELL | VARCHAR2 | (3) | 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. | ||
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. | |
USER_ACCESS_LEVEL | VARCHAR2 | (4000) | Access level for the user. | |
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 | Application Identifier | ||
RESOLVED_UNTIL | DATE | Date till which time-values have been resolved for long contracts. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
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 | |
KHR_ROW_ID | ROWID | (10) | ||
KHR_OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
ISG_ID | NUMBER | |||
KHR_ID | NUMBER | Foreign key to view OKL_K_HEADERS_V | ||
PDT_ID | NUMBER | Foreign key to view OKL_PRODUCTS_V | ||
AMD_CODE | VARCHAR2 | (30) | ||
DATE_FIRST_ACTIVITY | DATE | |||
GENERATE_ACCRUAL_YN | VARCHAR2 | (3) | ||
GENERATE_ACCRUAL_OVERRIDE_YN | VARCHAR2 | (3) | ||
DATE_REFINANCED | DATE | |||
CREDIT_ACT_YN | VARCHAR2 | (3) | ||
TERM_DURATION | NUMBER | (10) | ||
CONVERTED_ACCOUNT_YN | VARCHAR2 | (3) | ||
DATE_CONVERSION_EFFECTIVE | DATE | |||
SYNDICATABLE_YN | VARCHAR2 | (3) | ||
SALESTYPE_YN | VARCHAR2 | (3) | ||
DATE_DEAL_TRANSFERRED | DATE | |||
DATETIME_PROPOSAL_EFFECTIVE | DATE | |||
DATETIME_PROPOSAL_INEFFECTIVE | DATE | |||
DATE_PROPOSAL_ACCEPTED | DATE | |||
KHR_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
KHR_ATTRIBUTE1 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE2 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE3 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE4 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE5 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE6 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE7 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE8 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE9 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE10 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE11 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE12 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE13 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE14 | VARCHAR2 | (450) | ||
KHR_ATTRIBUTE15 | VARCHAR2 | (450) | ||
KHR_CREATED_BY | NUMBER | (15) | Yes | |
KHR_CREATON_DATE | DATE | Yes | ||
KHR_LAST_UPDATED_BY | NUMBER | (15) | Yes | |
KHR_LAST_UPDATE_DATE | DATE | Yes | ||
KHR_LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PRE_TAX_YIELD | NUMBER | |||
AFTER_TAX_YIELD | NUMBER | |||
IMPLICIT_INTEREST_RATE | NUMBER | |||
IMPLICIT_NON_IDC_INTEREST_RATE | NUMBER | |||
TARGET_PRE_TAX_YIELD | NUMBER | |||
TARGET_AFTER_TAX_YIELD | NUMBER | |||
TARGET_IMPLICIT_INTEREST_RATE | NUMBER | |||
TARGET_IMPLICIT_NONIDC_INTRATE | NUMBER | |||
DATE_LAST_INTERIM_INTEREST_CAL | DATE | |||
DEAL_TYPE | VARCHAR2 | (30) | ||
PRE_TAX_IRR | NUMBER | |||
AFTER_TAX_IRR | NUMBER | |||
EXPECTED_DELIVERY_DATE | DATE | |||
ACCEPTED_DATE | DATE | |||
PARTY_NAME | VARCHAR2 | (360) | Yes | Name of this party |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, CHR_ID_RESPONSE
, CHR_ID_AWARD
, CHR_ID_RENEWED
, INV_ORGANIZATION_ID
, STS_CODE
, STS_MEANING
, STE_CODE
, QCL_ID
, SCS_CODE
, SCS_MEANING
, RLE_CODE
, CONTRACT_NUMBER
, CURRENCY_CODE
, CONTRACT_NUMBER_MODIFIER
, ARCHIVED_YN
, DELETED_YN
, CUST_PO_NUMBER_REQ_YN
, PRE_PAY_REQ_YN
, CUST_PO_NUMBER
, SHORT_DESCRIPTION
, COMMENTS
, DESCRIPTION
, DPAS_RATING
, COGNOMEN
, TEMPLATE_YN
, TEMPLATE_USED
, DATE_APPROVED
, DATETIME_CANCELLED
, AUTO_RENEW_DAYS
, DATE_ISSUED
, DATETIME_RESPONDED
, NON_RESPONSE_REASON
, NON_RESPONSE_EXPLAIN
, RFP_TYPE
, CHR_TYPE
, KEEP_ON_MAIL_LIST
, SET_ASIDE_REASON
, SET_ASIDE_PERCENT
, RESPONSE_COPIES_REQ
, DATE_CLOSE_PROJECTED
, DATETIME_PROPOSED
, DATE_SIGNED
, DATE_TERMINATED
, DATE_RENEWED
, TRN_CODE
, START_DATE
, END_DATE
, AUTHORING_ORG_ID
, BUY_OR_SELL
, ISSUE_OR_RECEIVE
, ESTIMATED_AMOUNT
, CHR_ID_RENEWED_TO
, ESTIMATED_AMOUNT_RENEWED
, CURRENCY_CODE_RENEWED
, USER_ACCESS_LEVEL
, UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID
, APPLICATION_ID
, RESOLVED_UNTIL
, ATTRIBUTE_CATEGORY
, 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
, ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1
, KHR_ROW_ID
, KHR_OBJECT_VERSION_NUMBER
, ISG_ID
, KHR_ID
, PDT_ID
, AMD_CODE
, DATE_FIRST_ACTIVITY
, GENERATE_ACCRUAL_YN
, GENERATE_ACCRUAL_OVERRIDE_YN
, DATE_REFINANCED
, CREDIT_ACT_YN
, TERM_DURATION
, CONVERTED_ACCOUNT_YN
, DATE_CONVERSION_EFFECTIVE
, SYNDICATABLE_YN
, SALESTYPE_YN
, DATE_DEAL_TRANSFERRED
, DATETIME_PROPOSAL_EFFECTIVE
, DATETIME_PROPOSAL_INEFFECTIVE
, DATE_PROPOSAL_ACCEPTED
, KHR_ATTRIBUTE_CATEGORY
, KHR_ATTRIBUTE1
, KHR_ATTRIBUTE2
, KHR_ATTRIBUTE3
, KHR_ATTRIBUTE4
, KHR_ATTRIBUTE5
, KHR_ATTRIBUTE6
, KHR_ATTRIBUTE7
, KHR_ATTRIBUTE8
, KHR_ATTRIBUTE9
, KHR_ATTRIBUTE10
, KHR_ATTRIBUTE11
, KHR_ATTRIBUTE12
, KHR_ATTRIBUTE13
, KHR_ATTRIBUTE14
, KHR_ATTRIBUTE15
, KHR_CREATED_BY
, KHR_CREATON_DATE
, KHR_LAST_UPDATED_BY
, KHR_LAST_UPDATE_DATE
, KHR_LAST_UPDATE_LOGIN
, PRE_TAX_YIELD
, AFTER_TAX_YIELD
, IMPLICIT_INTEREST_RATE
, IMPLICIT_NON_IDC_INTEREST_RATE
, TARGET_PRE_TAX_YIELD
, TARGET_AFTER_TAX_YIELD
, TARGET_IMPLICIT_INTEREST_RATE
, TARGET_IMPLICIT_NONIDC_INTRATE
, DATE_LAST_INTERIM_INTEREST_CAL
, DEAL_TYPE
, PRE_TAX_IRR
, AFTER_TAX_IRR
, EXPECTED_DELIVERY_DATE
, ACCEPTED_DATE
, PARTY_NAME
FROM APPS.OKL_AM_CONTRACT_PARTIES_UV;
|
|
|