VIEW: APPS.OKE_K_LINES_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.APP_CODE , K.AS_OF_DATE , K.AUTHORITY , K.AWARD_FEE , K.AWARD_FEE_POOL_AMOUNT , K.BASE_FEE , K.BILLABLE_FLAG , K.BILLABLE_YN , K.BILLING_METHOD , K.BILLING_METHOD_CODE , K.BILL_UNDEFINITIZED_FLAG , K.BILL_UNDEFINITIZED_YN , K.BOE_DESCRIPTION , K.CDRL_CATEGORY , K.CEILING_COST , K.CEILING_PRICE , K.CFE_FLAG , K.CFE_YN , K.COMMENTS , K.COMPLETED_FLAG , K.COMPLETED_YN , K.COPIES_REQUIRED , K.COP_REQUIRED_FLAG , K.COP_REQUIRED_YN , K.COST_OF_MONEY , K.COST_OF_MONEY_YN , K.COST_OF_SALE_RATE , K.COST_OVERRUN_SHARE_RATIO , K.COST_UNDERRUN_SHARE_RATIO , K.COUNTRY_OF_ORIGIN_CODE , K.CUSTOMER_APPROVAL_REQ_FLAG , K.CUSTOMER_APPROVAL_REQ_YN , K.CUSTOMER_ITEM_ID , K.CUSTOMER_ITEM_NUMBER , K.CUSTOMER_PERCENT_IN_ORDER , K.C_SCS_FLAG , K.C_SCS_YN , K.C_SSR_FLAG , K.C_SSR_YN , K.DATA_ITEM_NAME , K.DATA_ITEM_SUBTITLE , K.DATE_MATERIAL_REQ , K.DATE_OF_FIRST_SUBMISSION , K.DATE_OF_PRICE_REDETERMIN , K.DCAA_AUDIT_REQ_FLAG , K.DCAA_AUDIT_REQ_YN , K.DEFINITIZED_FLAG , K.DEFINITIZED_YN , K.DELIVERY_DATE , K.DELIVERY_ORDER_FLAG , K.DISCOUNT_FOR_PAYMENT , K.DISPLAY_SEQUENCE , K.DROP_SHIPPED_FLAG , K.DROP_SHIPPED_YN , K.END_DATE , K.ESTIMATED_TOTAL_QUANTITY , K.EXPORT_FLAG , K.EXPORT_LICENSE_NUM , K.EXPORT_LICENSE_RES , K.EXPORT_YN , K.FEE_AJT_FORMULA , K.FINAL_FEE , K.FINAL_PFT_AJT_FORMULA , K.FINANCIAL_CTRL_FLAG , K.FINANCIAL_CTRL_YN , K.FIXED_FEE , K.FIXED_QUANTITY , K.FREQUENCY , K.HEADER_ID , K.INITIAL_FEE , K.INITIAL_PRICE , K.INSPECTION_REQ_FLAG , K.INSPECTION_REQ_YN , K.INTERIM_RPT_REQ_FLAG , K.INTERIM_RPT_REQ_YN , K.INVENTORY_ITEM_ID , K.ITEM_DESCRIPTION , K.ITEM_NUMBER , K.K_LINE_ID , K.LABOR_COST_INDEX , K.LEVEL_OF_EFFORT_HOURS , K.LINE_DESCRIPTION , K.LINE_LIQUIDATION_RATE , K.LINE_NUMBER , K.LINE_QUANTITY , K.LINE_STYLE , K.LINE_VALUE , K.LINE_VALUE_TOTAL , K.LSE_ID , K.MATERIAL_COST_INDEX , K.MAXIMUM_FEE , K.MAXIMUM_QUANTITY , K.MINIMUM_FEE , K.MINIMUM_QUANTITY , K.NSN_NUMBER , K.NSP_FLAG , K.NSP_YN , K.NTE_WARNING_FLAG , K.NTE_WARNING_YN , K.NUMBER_OF_OPTIONS , K.OBJECT_VERSION_NUMBER , K.PARENT_LINE_ID , K.PREPAYMENT_AMOUNT , K.PREPAYMENT_PERCENTAGE , K.PRIORITY_CODE , K.PRIORITY_RATING , 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.PROPOSAL_DUE_DATE , K.REQUIRING_OFFICE , K.REVISED_PRICE , K.SCHEDULED_DELV_DEFAULT , K.SFWT_FLAG , K.SHIPPABLE_FLAG , K.SHIPPABLE_YN , K.SPLITED_FLAG , K.START_DATE , K.STATUS , K.STATUS_CODE , K.SUBCONTRACTED_FLAG , K.SUBCONTRACTED_YN , K.SUBJ_A133_FLAG , K.SUBJ_A133_YN , K.TARGET_COST , K.TARGET_DATE_DEFINITIZE , K.TARGET_FEE , K.TARGET_PRICE , K.TASK_COMPLETION_DATE , K.TASK_DESCRIPTION , K.TASK_ID , K.TASK_NAME , K.TASK_NUMBER , K.TASK_ORGANIZATION , K.TASK_START_DATE , K.TOTAL_ESTIMATED_COST , K.TRN_CODE , K.UNDEF_LINE_VALUE , K.UNDEF_LINE_VALUE_TOTAL , K.UNDEF_UNIT_PRICE , K.UNIT_PRICE , K.UOM_CODE FROM OKE_K_LINES_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.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.APP_CODE
, K.AS_OF_DATE
, K.AUTHORITY
, K.AWARD_FEE
, K.AWARD_FEE_POOL_AMOUNT
, K.BASE_FEE
, K.BILLABLE_FLAG
, K.BILLABLE_YN
, K.BILLING_METHOD
, K.BILLING_METHOD_CODE
, K.BILL_UNDEFINITIZED_FLAG
, K.BILL_UNDEFINITIZED_YN
, K.BOE_DESCRIPTION
, K.CDRL_CATEGORY
, K.CEILING_COST
, K.CEILING_PRICE
, K.CFE_FLAG
, K.CFE_YN
, K.COMMENTS
, K.COMPLETED_FLAG
, K.COMPLETED_YN
, K.COPIES_REQUIRED
, K.COP_REQUIRED_FLAG
, K.COP_REQUIRED_YN
, K.COST_OF_MONEY
, K.COST_OF_MONEY_YN
, K.COST_OF_SALE_RATE
, K.COST_OVERRUN_SHARE_RATIO
, K.COST_UNDERRUN_SHARE_RATIO
, K.COUNTRY_OF_ORIGIN_CODE
, K.CUSTOMER_APPROVAL_REQ_FLAG
, K.CUSTOMER_APPROVAL_REQ_YN
, K.CUSTOMER_ITEM_ID
, K.CUSTOMER_ITEM_NUMBER
, K.CUSTOMER_PERCENT_IN_ORDER
, K.C_SCS_FLAG
, K.C_SCS_YN
, K.C_SSR_FLAG
, K.C_SSR_YN
, K.DATA_ITEM_NAME
, K.DATA_ITEM_SUBTITLE
, K.DATE_MATERIAL_REQ
, K.DATE_OF_FIRST_SUBMISSION
, K.DATE_OF_PRICE_REDETERMIN
, K.DCAA_AUDIT_REQ_FLAG
, K.DCAA_AUDIT_REQ_YN
, K.DEFINITIZED_FLAG
, K.DEFINITIZED_YN
, K.DELIVERY_DATE
, K.DELIVERY_ORDER_FLAG
, K.DISCOUNT_FOR_PAYMENT
, K.DISPLAY_SEQUENCE
, K.DROP_SHIPPED_FLAG
, K.DROP_SHIPPED_YN
, K.END_DATE
, K.ESTIMATED_TOTAL_QUANTITY
, K.EXPORT_FLAG
, K.EXPORT_LICENSE_NUM
, K.EXPORT_LICENSE_RES
, K.EXPORT_YN
, K.FEE_AJT_FORMULA
, K.FINAL_FEE
, K.FINAL_PFT_AJT_FORMULA
, K.FINANCIAL_CTRL_FLAG
, K.FINANCIAL_CTRL_YN
, K.FIXED_FEE
, K.FIXED_QUANTITY
, K.FREQUENCY
, K.HEADER_ID
, K.INITIAL_FEE
, K.INITIAL_PRICE
, K.INSPECTION_REQ_FLAG
, K.INSPECTION_REQ_YN
, K.INTERIM_RPT_REQ_FLAG
, K.INTERIM_RPT_REQ_YN
, K.INVENTORY_ITEM_ID
, K.ITEM_DESCRIPTION
, K.ITEM_NUMBER
, K.K_LINE_ID
, K.LABOR_COST_INDEX
, K.LEVEL_OF_EFFORT_HOURS
, K.LINE_DESCRIPTION
, K.LINE_LIQUIDATION_RATE
, K.LINE_NUMBER
, K.LINE_QUANTITY
, K.LINE_STYLE
, K.LINE_VALUE
, K.LINE_VALUE_TOTAL
, K.LSE_ID
, K.MATERIAL_COST_INDEX
, K.MAXIMUM_FEE
, K.MAXIMUM_QUANTITY
, K.MINIMUM_FEE
, K.MINIMUM_QUANTITY
, K.NSN_NUMBER
, K.NSP_FLAG
, K.NSP_YN
, K.NTE_WARNING_FLAG
, K.NTE_WARNING_YN
, K.NUMBER_OF_OPTIONS
, K.OBJECT_VERSION_NUMBER
, K.PARENT_LINE_ID
, K.PREPAYMENT_AMOUNT
, K.PREPAYMENT_PERCENTAGE
, K.PRIORITY_CODE
, K.PRIORITY_RATING
, 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.PROPOSAL_DUE_DATE
, K.REQUIRING_OFFICE
, K.REVISED_PRICE
, K.SCHEDULED_DELV_DEFAULT
, K.SFWT_FLAG
, K.SHIPPABLE_FLAG
, K.SHIPPABLE_YN
, K.SPLITED_FLAG
, K.START_DATE
, K.STATUS
, K.STATUS_CODE
, K.SUBCONTRACTED_FLAG
, K.SUBCONTRACTED_YN
, K.SUBJ_A133_FLAG
, K.SUBJ_A133_YN
, K.TARGET_COST
, K.TARGET_DATE_DEFINITIZE
, K.TARGET_FEE
, K.TARGET_PRICE
, K.TASK_COMPLETION_DATE
, K.TASK_DESCRIPTION
, K.TASK_ID
, K.TASK_NAME
, K.TASK_NUMBER
, K.TASK_ORGANIZATION
, K.TASK_START_DATE
, K.TOTAL_ESTIMATED_COST
, K.TRN_CODE
, K.UNDEF_LINE_VALUE
, K.UNDEF_LINE_VALUE_TOTAL
, K.UNDEF_UNIT_PRICE
, K.UNIT_PRICE
, K.UOM_CODE
FROM OKE_K_LINES_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.HEADER_ID
AND ACC.K_ACCESS IN ( 'EDIT'
, 'VIEW' )