VIEW: APPS.OKE_K_LINES_FWDN_V

Source

View Text - Preformatted

SELECT ROW_ID , K_LINE_ID , MAJOR_VERSION , MINOR_VERSION , VERSION_DISP , OBJECT_VERSION_NUMBER , SFWT_FLAG , DISPLAY_SEQUENCE , LSE_ID , LINE_STYLE , LINE_NUMBER , LINE_DESCRIPTION , STATUS_CODE , STATUS , START_DATE , END_DATE , PRIORITY_CODE , PRIORITY_RATING , DELIVERY_DATE , PROPOSAL_DUE_DATE , INVENTORY_ITEM_ID , ITEM_NUMBER , ITEM_DESCRIPTION , PROJECT_ID , PROJECT_NUMBER , PROJECT_NAME , PROJECT_DESCRIPTION , PROJECT_START_DATE , PROJECT_COMPLETION_DATE , PROJECT_ORGANIZATION , TASK_ID , TASK_NUMBER , TASK_NAME , TASK_DESCRIPTION , TASK_START_DATE , TASK_COMPLETION_DATE , TASK_ORGANIZATION , DELIVERY_ORDER_FLAG , SPLITED_FLAG , LINE_QUANTITY , TO_CHAR( LINE_VALUE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , BILLABLE_FLAG , BILLABLE_YN , COMPLETED_FLAG , COMPLETED_YN , EXPORT_FLAG , EXPORT_YN , PARENT_LINE_ID , HEADER_ID , TO_CHAR( UNIT_PRICE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , UOM_CODE , SHIPPABLE_FLAG , SHIPPABLE_YN , SUBCONTRACTED_FLAG , SUBCONTRACTED_YN , NSP_FLAG , NSP_YN , CUSTOMER_APPROVAL_REQ_FLAG , CUSTOMER_APPROVAL_REQ_YN , COMMENTS , COST_OF_MONEY , COST_OF_MONEY_YN , PREPAYMENT_PERCENTAGE , TO_CHAR( PREPAYMENT_AMOUNT , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , BOE_DESCRIPTION , PROGRESS_PAYMENT_FLAG , PROGRESS_PAYMENT_YN , PROGRESS_PAYMENT_LIQ_RATE , LINE_LIQUIDATION_RATE , PROGRESS_PAYMENT_RATE , DISCOUNT_FOR_PAYMENT , DCAA_AUDIT_REQ_FLAG , DCAA_AUDIT_REQ_YN , INTERIM_RPT_REQ_FLAG , INTERIM_RPT_REQ_YN , BILL_UNDEFINITIZED_FLAG , BILL_UNDEFINITIZED_YN , FINANCIAL_CTRL_FLAG , FINANCIAL_CTRL_YN , C_SSR_FLAG , C_SSR_YN , C_SCS_FLAG , C_SCS_YN , BILLING_METHOD_CODE , BILLING_METHOD , LEVEL_OF_EFFORT_HOURS , TO_CHAR( CEILING_PRICE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( CEILING_COST , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( TOTAL_ESTIMATED_COST , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( AWARD_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( AWARD_FEE_POOL_AMOUNT , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( BASE_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( FIXED_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( MAXIMUM_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( MINIMUM_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( INITIAL_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( FINAL_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , DROP_SHIPPED_FLAG , DROP_SHIPPED_YN , EXPORT_LICENSE_NUM , EXPORT_LICENSE_RES , MATERIAL_COST_INDEX , LABOR_COST_INDEX , COST_OVERRUN_SHARE_RATIO , COST_UNDERRUN_SHARE_RATIO , FEE_AJT_FORMULA , FIXED_QUANTITY , ESTIMATED_TOTAL_QUANTITY , MAXIMUM_QUANTITY , MINIMUM_QUANTITY , NUMBER_OF_OPTIONS , TO_CHAR( TARGET_FEE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( TARGET_PRICE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , FINAL_PFT_AJT_FORMULA , TO_CHAR( TARGET_COST , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TARGET_DATE_DEFINITIZE , DEFINITIZED_FLAG , DEFINITIZED_YN , DATE_OF_PRICE_REDETERMIN , TO_CHAR( INITIAL_PRICE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , TO_CHAR( REVISED_PRICE , OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID , 38 ) ) , CUSTOMER_PERCENT_IN_ORDER , COUNTRY_OF_ORIGIN_CODE , CUSTOMER_ITEM_ID , CUSTOMER_ITEM_NUMBER , APP_CODE , NSN_NUMBER , AS_OF_DATE , DATE_MATERIAL_REQ , AUTHORITY , NTE_WARNING_FLAG , NTE_WARNING_YN , COP_REQUIRED_FLAG , COP_REQUIRED_YN , INSPECTION_REQ_FLAG , INSPECTION_REQ_YN , SUBJ_A133_FLAG , SUBJ_A133_YN , CFE_FLAG , CFE_YN , DATA_ITEM_NAME , CDRL_CATEGORY , DATA_ITEM_SUBTITLE , REQUIRING_OFFICE , FREQUENCY , DATE_OF_FIRST_SUBMISSION , COPIES_REQUIRED , COST_OF_SALE_RATE , LINE_VALUE_TOTAL , UNDEF_UNIT_PRICE , UNDEF_LINE_VALUE , UNDEF_LINE_VALUE_TOTAL , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , LAST_UPDATE_DATE , TRN_CODE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 FROM OKE_K_LINES_SECURE_V

View Text - HTML Formatted

SELECT ROW_ID
, K_LINE_ID
, MAJOR_VERSION
, MINOR_VERSION
, VERSION_DISP
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, DISPLAY_SEQUENCE
, LSE_ID
, LINE_STYLE
, LINE_NUMBER
, LINE_DESCRIPTION
, STATUS_CODE
, STATUS
, START_DATE
, END_DATE
, PRIORITY_CODE
, PRIORITY_RATING
, DELIVERY_DATE
, PROPOSAL_DUE_DATE
, INVENTORY_ITEM_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, PROJECT_START_DATE
, PROJECT_COMPLETION_DATE
, PROJECT_ORGANIZATION
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, TASK_DESCRIPTION
, TASK_START_DATE
, TASK_COMPLETION_DATE
, TASK_ORGANIZATION
, DELIVERY_ORDER_FLAG
, SPLITED_FLAG
, LINE_QUANTITY
, TO_CHAR( LINE_VALUE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, BILLABLE_FLAG
, BILLABLE_YN
, COMPLETED_FLAG
, COMPLETED_YN
, EXPORT_FLAG
, EXPORT_YN
, PARENT_LINE_ID
, HEADER_ID
, TO_CHAR( UNIT_PRICE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, UOM_CODE
, SHIPPABLE_FLAG
, SHIPPABLE_YN
, SUBCONTRACTED_FLAG
, SUBCONTRACTED_YN
, NSP_FLAG
, NSP_YN
, CUSTOMER_APPROVAL_REQ_FLAG
, CUSTOMER_APPROVAL_REQ_YN
, COMMENTS
, COST_OF_MONEY
, COST_OF_MONEY_YN
, PREPAYMENT_PERCENTAGE
, TO_CHAR( PREPAYMENT_AMOUNT
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, BOE_DESCRIPTION
, PROGRESS_PAYMENT_FLAG
, PROGRESS_PAYMENT_YN
, PROGRESS_PAYMENT_LIQ_RATE
, LINE_LIQUIDATION_RATE
, PROGRESS_PAYMENT_RATE
, DISCOUNT_FOR_PAYMENT
, DCAA_AUDIT_REQ_FLAG
, DCAA_AUDIT_REQ_YN
, INTERIM_RPT_REQ_FLAG
, INTERIM_RPT_REQ_YN
, BILL_UNDEFINITIZED_FLAG
, BILL_UNDEFINITIZED_YN
, FINANCIAL_CTRL_FLAG
, FINANCIAL_CTRL_YN
, C_SSR_FLAG
, C_SSR_YN
, C_SCS_FLAG
, C_SCS_YN
, BILLING_METHOD_CODE
, BILLING_METHOD
, LEVEL_OF_EFFORT_HOURS
, TO_CHAR( CEILING_PRICE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( CEILING_COST
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( TOTAL_ESTIMATED_COST
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( AWARD_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( AWARD_FEE_POOL_AMOUNT
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( BASE_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( FIXED_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( MAXIMUM_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( MINIMUM_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( INITIAL_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( FINAL_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, DROP_SHIPPED_FLAG
, DROP_SHIPPED_YN
, EXPORT_LICENSE_NUM
, EXPORT_LICENSE_RES
, MATERIAL_COST_INDEX
, LABOR_COST_INDEX
, COST_OVERRUN_SHARE_RATIO
, COST_UNDERRUN_SHARE_RATIO
, FEE_AJT_FORMULA
, FIXED_QUANTITY
, ESTIMATED_TOTAL_QUANTITY
, MAXIMUM_QUANTITY
, MINIMUM_QUANTITY
, NUMBER_OF_OPTIONS
, TO_CHAR( TARGET_FEE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( TARGET_PRICE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, FINAL_PFT_AJT_FORMULA
, TO_CHAR( TARGET_COST
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TARGET_DATE_DEFINITIZE
, DEFINITIZED_FLAG
, DEFINITIZED_YN
, DATE_OF_PRICE_REDETERMIN
, TO_CHAR( INITIAL_PRICE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, TO_CHAR( REVISED_PRICE
, OKE_UTILS.GET_K_CURR_FMT_MASK( HEADER_ID
, 38 ) )
, CUSTOMER_PERCENT_IN_ORDER
, COUNTRY_OF_ORIGIN_CODE
, CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_NUMBER
, APP_CODE
, NSN_NUMBER
, AS_OF_DATE
, DATE_MATERIAL_REQ
, AUTHORITY
, NTE_WARNING_FLAG
, NTE_WARNING_YN
, COP_REQUIRED_FLAG
, COP_REQUIRED_YN
, INSPECTION_REQ_FLAG
, INSPECTION_REQ_YN
, SUBJ_A133_FLAG
, SUBJ_A133_YN
, CFE_FLAG
, CFE_YN
, DATA_ITEM_NAME
, CDRL_CATEGORY
, DATA_ITEM_SUBTITLE
, REQUIRING_OFFICE
, FREQUENCY
, DATE_OF_FIRST_SUBMISSION
, COPIES_REQUIRED
, COST_OF_SALE_RATE
, LINE_VALUE_TOTAL
, UNDEF_UNIT_PRICE
, UNDEF_LINE_VALUE
, UNDEF_LINE_VALUE_TOTAL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, TRN_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM OKE_K_LINES_SECURE_V