Product: | OKE - Project Contracts |
---|---|
Description: | Contract line view for flowdown |
Implementation/DBA Data: | APPS.OKE_K_LINES_FWDN_V |
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