[Home] [Help] [Dependency Information]
Object Name: | OKE_K_HEADERS_SECURE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_HEADERS_SECURE_V |
Subobject Name: | |
Status: | VALID |
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 f. 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.
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 | Major version number of contract document | ||
MINOR_VERSION | NUMBER | Yes | Minor version number of contract document (not currently used) | |
VERSION_DISP | VARCHAR2 | (81) | 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 |
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_V;
|
|
|