VIEW: APPS.OKE_K_HEADERS_SECURE_HV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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