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

VIEW: APPS.OKE_K_HEADERS_SECURE_HV

Object Details
Object Name: OKE_K_HEADERS_SECURE_HV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_K_HEADERS_SECURE_HV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This secured view is used for controlling header level field access for archived contract. When shipped, this view does not contain attribute security logic.This basic version of this view is provided for compilation and code generation purposes. Upon completion of the security access rule definitions, this view get generated dynamically using the Generate Security Views process.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database generated row identifier
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield attribute context
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield attribute
MAJOR_VERSION NUMBER
Yes Major version number of contract document
MINOR_VERSION NUMBER

Minor version number of contract document (not currently used)
VERSION_DISP VARCHAR2 (42)
Concatenation of major version and minor version for display purposes
ALTERNATE_LIQUIDATION_RATE NUMBER

Alternate Liquidation Rate
AUTHORING_ORG VARCHAR2 (240)
Contract Authoring (Owning) Organization
AUTHORING_ORG_ID NUMBER
Yes Contract Authoring (Owning) Organization unique identifier
AUTHORIZE_DATE DATE

Authorize Date
AUTHORIZING_REASON VARCHAR2 (240)
Authorizing Reason
AWARD_CANCEL_DATE DATE

Award Cancel Date
AWARD_DATE DATE

Contract Award Date
BILL_WITHOUT_DEF_FLAG VARCHAR2 (1)
Bill Without Definitized indicator
BILL_WITHOUT_DEF_YN VARCHAR2 (4000)
Bill Without Definitized?
BOA_ID NUMBER

Basic Order Agreement unique identifier
BOA_NUMBER VARCHAR2 (120)
Basic Order Agreement Number
BOOKED_FLAG VARCHAR2 (1)
Booked indicator
BOOKED_YN VARCHAR2 (4000)
Booked?
BUY_OR_SELL VARCHAR2 (3)
Contract intent
CAS_FLAG VARCHAR2 (1)
Cost Accounting Standards Applies indicator
CAS_YN VARCHAR2 (4000)
Cost Accounting Standards Applies?
CFE_FLAG VARCHAR2 (1)
Customer Furnished Equipment Required indicator
CFE_YN VARCHAR2 (4000)
Customer Furnished Equipment Required?
CHR_TYPE VARCHAR2 (30) Yes OKC Contract Type
CLASSIFIED_FLAG VARCHAR2 (1)
Classified indicator
CLASSIFIED_YN VARCHAR2 (4000)
Classified?
CLIENT_APPROVE_REQ_FLAG VARCHAR2 (1)
Client Approval Required indicator
CLIENT_APPROVE_REQ_YN VARCHAR2 (4000)
Client Approval Required?
COMMENTS VARCHAR2 (1995)
User-entered comments
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract Number Modifier
COPIES_REQUIRED NUMBER

Copies of Response Required
COST_OF_MONEY VARCHAR2 (1)
Cost of Money Applies indicator
COST_OF_MONEY_YN VARCHAR2 (4000)
Cost of Money Applies?
COST_OF_SALE_RATE NUMBER

Cost of Sale Rate
COST_SHARE_FLAG VARCHAR2 (1)
Cost Share indicator
COST_SHARE_YN VARCHAR2 (4000)
Cost Share?
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (30)
Country of origin
CQA_FLAG VARCHAR2 (1)
Customer Quality Acceptance Required indicator
CQA_YN VARCHAR2 (4000)
Customer Quality Acceptance Required?
CURRENCY_CODE VARCHAR2 (15)
Currency
CUSTOMER_PO_NUMBER VARCHAR2 (150)
Customer PO Number
DATE_APPROVED DATE

Date Approved
DATE_DEFINITIZED DATE

Date Definitized
DATE_ISSUED DATE

Date Issued
DATE_NEGOTIATED DATE

Date Negotiated
DATE_RECEIVED DATE

Date Received
DATE_SIGN_BY_CONTRACTOR DATE

Date Signed by Contractor
DATE_SIGN_BY_CUSTOMER DATE

Date Signed by Customer
DCAA_AUDIT_REQ_FLAG VARCHAR2 (1)
DCAA Audit Required indicator
DCAA_AUDIT_REQ_YN VARCHAR2 (4000)
DCAA Audit Required?
DEFAULT_TASK_ID NUMBER

Task Id of the task to be defaulted on contract lines. Used only for defaulting.
DEFAULT_TASK_NUMBER VARCHAR2 (25)
Task number of the task to be defaulted on contract lines. Used only for defaulting.
DEFINITIZED_FLAG VARCHAR2 (1)
Definitized indicator
DEFINITIZED_YN VARCHAR2 (4000)
Definitized?
DESCRIPTION VARCHAR2 (1995)
Description of contract document
END_DATE DATE

Date when contract document is no longer active (expired)
EXPORT_FLAG VARCHAR2 (1)
Export indicator
EXPORT_YN VARCHAR2 (4000)
Export Required?
FAA_APPROVE_DATE DATE

First Article Approve Date
FAA_REJECT_DATE DATE

First Article Reject Date
FINANCIAL_CTRL_VERIFIED_FLAG VARCHAR2 (1)
Financial Control Verified indicator
FINANCIAL_CTRL_VERIFIED_YN VARCHAR2 (4000)
Financial Control Verified?
HUMAN_SUBJECT_FLAG VARCHAR2 (1)
Human Subject Applies indicator
HUMAN_SUBJECT_YN VARCHAR2 (4000)
Human Subject Applies?
INTERIM_RPT_REQ_FLAG VARCHAR2 (1)
Interim report required indicator
INTERIM_RPT_REQ_YN VARCHAR2 (4000)
Interim Report Required?
ISSUE_OR_RECEIVE VARCHAR2 (3)
Perspective
K_ALIAS VARCHAR2 (300)
Contract alias
K_HEADER_ID NUMBER
Yes Contract document unique identifier
K_NUMBER VARCHAR2 (120) Yes Contract document number
K_TYPE VARCHAR2 (80) Yes Contract document type name
K_TYPE_CODE VARCHAR2 (30) Yes Internal identifier for contract document type
K_VALUE NUMBER

Contract Value
LINE_VALUE_TOTAL NUMBER

Line Value Total
NO_COMPETITION_AUTHORIZE VARCHAR2 (80)
Non-competition justification
NTE_AMOUNT NUMBER

Not To Exceed Amount
NTE_WARNING_FLAG VARCHAR2 (1)
Not To Exceed Warning indicator
NTE_WARNING_YN VARCHAR2 (4000)
Not To Exceed Warning?
OBJECT_VERSION_NUMBER NUMBER (9) Yes Internal object version number
OH_RATES_FINAL_FLAG VARCHAR2 (1)
Overhead Rates Finalized indicator
OH_RATES_FINAL_YN VARCHAR2 (4000)
Overhead Rates Finalized?
OPEN_FLAG VARCHAR2 (1)
Open indicator
OPEN_YN VARCHAR2 (4000)
Open?
OWNING_ORGANIZATION VARCHAR2 (240)
Owning organization name
OWNING_ORGANIZATION_ID NUMBER

Owning Organization unique identifier
PENALTY_CLAUSE_FLAG VARCHAR2 (1)
Penalty Clause Applies indicator
PENALTY_CLAUSE_YN VARCHAR2 (4000)
Penalty Clause Applies?
PRIME_K_ALIAS VARCHAR2 (30)
Prime Contract Alias
PRIME_K_NUMBER VARCHAR2 (30)
Prime Contract Number
PRIORITY_CODE VARCHAR2 (30)
Priority rating of contract document
PRIORITY_RATING VARCHAR2 (80)
Priority Rating
PRODUCT_LINE VARCHAR2 (80)
Product Line
PRODUCT_LINE_CODE VARCHAR2 (30)
Product Line Code
PROGRAM_ID NUMBER

Program unique identifier
PROGRAM_NUMBER VARCHAR2 (80)
Program number
PROGRESS_PAYMENT_FLAG VARCHAR2 (1)
Progress Payment Applies indicator
PROGRESS_PAYMENT_LIQ_RATE NUMBER

Progress Payment Liquidation Rate
PROGRESS_PAYMENT_RATE NUMBER

Progress Payment Rate
PROGRESS_PAYMENT_YN VARCHAR2 (4000)
Progress Payment Applies?
PROJECT_COMPLETION_DATE DATE

Project Completion Date
PROJECT_DESCRIPTION VARCHAR2 (250)
Project description
PROJECT_ID NUMBER

System generated project unique identifier
PROJECT_NAME VARCHAR2 (30)
Project name
PROJECT_NUMBER VARCHAR2 (25)
Project number
PROJECT_ORGANIZATION VARCHAR2 (240)
Project Organization
PROJECT_START_DATE DATE

Project Start Date
PROP_DELIVERY_LOCATION VARCHAR2 (150)
Proposal Delivery Location
PROP_DUE_DATE_TIME DATE

Proposal Due Date
PROP_DUE_TIME VARCHAR2 (80)
Proposal Due
PROP_EXPIRE_DATE DATE

Proposal Expiry Date
QCL_ID NUMBER

Quality Check List unique identifier
REPORTING_FLAG VARCHAR2 (1)
Reporting Required indicator
REPORTING_YN VARCHAR2 (4000)
Reporting Required?
SB_PLAN_REQ_FLAG VARCHAR2 (1)
Small Business Plan Required indicator
SB_PLAN_REQ_YN VARCHAR2 (4000)
Small Business Plan Required?
SB_REPORT_FLAG VARCHAR2 (1)
Small Business Report Required indicator
SB_REPORT_YN VARCHAR2 (4000)
Small Business Report Required?
SCS_CODE VARCHAR2 (30) Yes Contract Category Code
SHORT_DESCRIPTION VARCHAR2 (600)
Short Description
SIC_CODE VARCHAR2 (30)
Industry Classification
START_DATE DATE

Date when contract document becomes effective
STATUS VARCHAR2 (90) Yes Contract Status
STATUS_CODE VARCHAR2 (30) Yes Contract Status Code
TECH_DATA_WH_RATE NUMBER

Technical Data Withholding Rate
TEMPLATE_YN VARCHAR2 (3) Yes Template indicator
TEMPLATE_YN_DSP VARCHAR2 (4000)
Template?
TRN_CODE VARCHAR2 (30)
Contract line termination code
TYPE_CLASS_CODE VARCHAR2 (30) Yes Contract document type class code
UNDEF_LINE_VALUE_TOTAL NUMBER

Undefinitized Line Value Total
VAT_CODE VARCHAR2 (30)
VAT Code
Query Text

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


SELECT ROW_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MAJOR_VERSION
,      MINOR_VERSION
,      VERSION_DISP
,      ALTERNATE_LIQUIDATION_RATE
,      AUTHORING_ORG
,      AUTHORING_ORG_ID
,      AUTHORIZE_DATE
,      AUTHORIZING_REASON
,      AWARD_CANCEL_DATE
,      AWARD_DATE
,      BILL_WITHOUT_DEF_FLAG
,      BILL_WITHOUT_DEF_YN
,      BOA_ID
,      BOA_NUMBER
,      BOOKED_FLAG
,      BOOKED_YN
,      BUY_OR_SELL
,      CAS_FLAG
,      CAS_YN
,      CFE_FLAG
,      CFE_YN
,      CHR_TYPE
,      CLASSIFIED_FLAG
,      CLASSIFIED_YN
,      CLIENT_APPROVE_REQ_FLAG
,      CLIENT_APPROVE_REQ_YN
,      COMMENTS
,      CONTRACT_NUMBER_MODIFIER
,      COPIES_REQUIRED
,      COST_OF_MONEY
,      COST_OF_MONEY_YN
,      COST_OF_SALE_RATE
,      COST_SHARE_FLAG
,      COST_SHARE_YN
,      COUNTRY_OF_ORIGIN_CODE
,      CQA_FLAG
,      CQA_YN
,      CURRENCY_CODE
,      CUSTOMER_PO_NUMBER
,      DATE_APPROVED
,      DATE_DEFINITIZED
,      DATE_ISSUED
,      DATE_NEGOTIATED
,      DATE_RECEIVED
,      DATE_SIGN_BY_CONTRACTOR
,      DATE_SIGN_BY_CUSTOMER
,      DCAA_AUDIT_REQ_FLAG
,      DCAA_AUDIT_REQ_YN
,      DEFAULT_TASK_ID
,      DEFAULT_TASK_NUMBER
,      DEFINITIZED_FLAG
,      DEFINITIZED_YN
,      DESCRIPTION
,      END_DATE
,      EXPORT_FLAG
,      EXPORT_YN
,      FAA_APPROVE_DATE
,      FAA_REJECT_DATE
,      FINANCIAL_CTRL_VERIFIED_FLAG
,      FINANCIAL_CTRL_VERIFIED_YN
,      HUMAN_SUBJECT_FLAG
,      HUMAN_SUBJECT_YN
,      INTERIM_RPT_REQ_FLAG
,      INTERIM_RPT_REQ_YN
,      ISSUE_OR_RECEIVE
,      K_ALIAS
,      K_HEADER_ID
,      K_NUMBER
,      K_TYPE
,      K_TYPE_CODE
,      K_VALUE
,      LINE_VALUE_TOTAL
,      NO_COMPETITION_AUTHORIZE
,      NTE_AMOUNT
,      NTE_WARNING_FLAG
,      NTE_WARNING_YN
,      OBJECT_VERSION_NUMBER
,      OH_RATES_FINAL_FLAG
,      OH_RATES_FINAL_YN
,      OPEN_FLAG
,      OPEN_YN
,      OWNING_ORGANIZATION
,      OWNING_ORGANIZATION_ID
,      PENALTY_CLAUSE_FLAG
,      PENALTY_CLAUSE_YN
,      PRIME_K_ALIAS
,      PRIME_K_NUMBER
,      PRIORITY_CODE
,      PRIORITY_RATING
,      PRODUCT_LINE
,      PRODUCT_LINE_CODE
,      PROGRAM_ID
,      PROGRAM_NUMBER
,      PROGRESS_PAYMENT_FLAG
,      PROGRESS_PAYMENT_LIQ_RATE
,      PROGRESS_PAYMENT_RATE
,      PROGRESS_PAYMENT_YN
,      PROJECT_COMPLETION_DATE
,      PROJECT_DESCRIPTION
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      PROJECT_ORGANIZATION
,      PROJECT_START_DATE
,      PROP_DELIVERY_LOCATION
,      PROP_DUE_DATE_TIME
,      PROP_DUE_TIME
,      PROP_EXPIRE_DATE
,      QCL_ID
,      REPORTING_FLAG
,      REPORTING_YN
,      SB_PLAN_REQ_FLAG
,      SB_PLAN_REQ_YN
,      SB_REPORT_FLAG
,      SB_REPORT_YN
,      SCS_CODE
,      SHORT_DESCRIPTION
,      SIC_CODE
,      START_DATE
,      STATUS
,      STATUS_CODE
,      TECH_DATA_WH_RATE
,      TEMPLATE_YN
,      TEMPLATE_YN_DSP
,      TRN_CODE
,      TYPE_CLASS_CODE
,      UNDEF_LINE_VALUE_TOTAL
,      VAT_CODE
FROM APPS.OKE_K_HEADERS_SECURE_HV;

Dependencies

[top of page]

APPS.OKE_K_HEADERS_SECURE_HV references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
ViewOKE_K_HEADERS_FULL_HV
PL/SQL PackageOKE_K_SECURITY_PKG - show dependent code
PL/SQL PackageOKE_UTILS - show dependent code
APPS.OKE_K_HEADERS_SECURE_HV is referenced by following:

SchemaAPPS
Package BodyOKE_VERSION_COMPARISON_PKG - show dependent code