View: OKS_AUTH_LINES_V

Product:	OKS - Service Contracts
Description:
Implementation/DBA Data:	APPS.OKS_AUTH_LINES_V

View Text

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.CHR_ID CHR_ID
, CLEB.CLE_ID CLE_ID
, CLEB.CLE_ID_RENEWED CLE_ID_RENEWED
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLEB.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, CLEB.STS_CODE STS_CODE
, CLEB.TRN_CODE TRN_CODE
, CLEB.LSE_ID LSE_ID
, CLEB.EXCEPTION_YN EXCEPTION_YN
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.HIDDEN_IND HIDDEN_IND
, CLEB.PRICE_NEGOTIATED PRICE_NEGOTIATED
, CLEB.PRICE_LEVEL_IND PRICE_LEVEL_IND
, CLEB.PRICE_UNIT PRICE_UNIT
, CLEB.PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT
, CLEB.INVOICE_LINE_LEVEL_IND INVOICE_LINE_LEVEL_IND
, CLEB.DPAS_RATING DPAS_RATING
, CLEB.TEMPLATE_USED TEMPLATE_USED
, CLEB.PRICE_TYPE PRICE_TYPE
, CLEB.CURRENCY_CODE CURRENCY_CODE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CLEB.DATE_TERMINATED DATE_TERMINATED
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CLEB.CLE_ID_RENEWED_TO CLE_ID_RENEWED_TO
, CLEB.PRICE_NEGOTIATED_RENEWED PRICE_NEGOTIATED_RENEWED
, CLEB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, CLEB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CLEB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, CLEB.DATE_RENEWED DATE_RENEWED
, CLEB.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, CLEB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, CLEB.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, CLEB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CLEB.PROGRAM_ID PROGRAM_ID
, CLEB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CLEB.REQUEST_ID REQUEST_ID
, CLEB.PRICE_LIST_ID PRICE_LIST_ID
, CLEB.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, CLEB.LINE_LIST_PRICE LINE_LIST_PRICE
, CLEB.ITEM_TO_PRICE_YN ITEM_TO_PRICE_YN
, CLEB.PRICING_DATE PRICING_DATE
, CLEB.PRICE_BASIS_YN PRICE_BASIS_YN
, CLEB.CONFIG_HEADER_ID CONFIG_HEADER_ID
, CLEB.CONFIG_REVISION_NUMBER CONFIG_REVISION_NUMBER
, CLEB.CONFIG_COMPLETE_YN CONFIG_COMPLETE_YN
, CLEB.CONFIG_VALID_YN CONFIG_VALID_YN
, CLEB.CONFIG_TOP_MODEL_LINE_ID CONFIG_TOP_MODEL_LINE_ID
, CLEB.CONFIG_ITEM_TYPE CONFIG_ITEM_TYPE
, CLEB.CONFIG_ITEM_ID CONFIG_ITEM_ID
, CLEB.SERVICE_ITEM_YN SERVICE_ITEM_YN
, CLEB.PH_PRICING_TYPE PH_PRICING_TYPE
, CLEB.PH_PRICE_BREAK_BASIS PH_PRICE_BREAK_BASIS
, CLEB.PH_MIN_QTY PH_MIN_QTY
, CLEB.PH_MIN_AMT PH_MIN_AMT
, CLEB.PH_QP_REFERENCE_ID PH_QP_REFERENCE_ID
, CLEB.PH_VALUE PH_VALUE
, CLEB.PH_ENFORCE_PRICE_LIST_YN PH_ENFORCE_PRICE_LIST_YN
, CLEB.PH_ADJUSTMENT PH_ADJUSTMENT
, CLEB.PH_INTEGRATED_WITH_QP PH_INTEGRATED_WITH_QP
, CLEB.CUST_ACCT_ID CUST_ACCT_ID
, CLEB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CLEB.INV_RULE_ID INV_RULE_ID
, CLEB.LINE_RENEWAL_TYPE_CODE LINE_RENEWAL_TYPE_CODE
, CLEB.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, CLEB.PAYMENT_TERM_ID PAYMENT_TERM_ID
, CLET.LANGUAGE LANGUAGE
, CLET.SOURCE_LANG SOURCE_LANG
, CLET.SFWT_FLAG SFWT_FLAG
, CLET.NAME NAME
, CLET.COMMENTS COMMENTS
, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLET.BLOCK23TEXT BLOCK23TEXT
, CLET.OKE_BOE_DESCRIPTION OKE_BOE_DESCRIPTION
, CLET.COGNOMEN COGNOMEN
, KLN.ID KLN_ID
, KLN.DISCOUNT_LIST DISCOUNT_LIST
, KLN.ACCT_RULE_ID ACCT_RULE_ID
, KLN.PAYMENT_TYPE PAYMENT_TYPE
, KLN.CC_NO CC_NO
, KLN.CC_EXPIRY_DATE CC_EXPIRY_DATE
, KLN.CC_BANK_ACCT_ID CC_BANK_ACCT_ID
, KLN.CC_AUTH_CODE CC_AUTH_CODE
, KLN.COMMITMENT_ID COMMITMENT_ID
, KLN.LOCKED_PRICE_LIST_ID LOCKED_PRICE_LIST_ID
, KLN.USAGE_EST_YN USAGE_EST_YN
, KLN.USAGE_EST_METHOD USAGE_EST_METHOD
, KLN.USAGE_EST_START_DATE USAGE_EST_START_DATE
, KLN.TERMN_METHOD TERMN_METHOD
, KLN.UBT_AMOUNT UBT_AMOUNT
, KLN.CREDIT_AMOUNT CREDIT_AMOUNT
, KLN.SUPPRESSED_CREDIT SUPPRESSED_CREDIT
, KLN.OVERRIDE_AMOUNT OVERRIDE_AMOUNT
, KLN.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN
, KLN.CUST_PO_NUMBER CUST_PO_NUMBER
, KLN.GRACE_DURATION GRACE_DURATION
, KLN.GRACE_PERIOD GRACE_PERIOD
, KLN.INV_PRINT_FLAG INV_PRINT_FLAG
, KLN.PRICE_UOM PRICE_UOM
, KLN.TAX_AMOUNT TAX_AMOUNT
, KLN.TAX_INCLUSIVE_YN TAX_INCLUSIVE_YN
, KLN.TAX_STATUS TAX_STATUS
, KLN.TAX_CODE TAX_CODE
, KLN.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, KLN.IB_TRANS_TYPE IB_TRANS_TYPE
, KLN.IB_TRANS_DATE IB_TRANS_DATE
, KLN.PROD_PRICE PROD_PRICE
, KLN.SERVICE_PRICE SERVICE_PRICE
, KLN.CLVL_LIST_PRICE CLVL_LIST_PRICE
, KLN.CLVL_QUANTITY CLVL_QUANTITY
, KLN.CLVL_EXTENDED_AMT CLVL_EXTENDED_AMT
, KLN.CLVL_UOM_CODE CLVL_UOM_CODE
, KLN.TOPLVL_OPERAND_CODE TOPLVL_OPERAND_CODE
, KLN.TOPLVL_OPERAND_VAL TOPLVL_OPERAND_VAL
, KLN.TOPLVL_QUANTITY TOPLVL_QUANTITY
, KLN.TOPLVL_UOM_CODE TOPLVL_UOM_CODE
, KLN.TOPLVL_ADJ_PRICE TOPLVL_ADJ_PRICE
, KLN.TOPLVL_PRICE_QTY TOPLVL_PRICE_QTY
, KLN.AVERAGING_INTERVAL AVERAGING_INTERVAL
, KLN.SETTLEMENT_INTERVAL SETTLEMENT_INTERVAL
, KLN.MINIMUM_QUANTITY MINIMUM_QUANTITY
, KLN.DEFAULT_QUANTITY DEFAULT_QUANTITY
, KLN.AMCV_FLAG AMCV_FLAG
, KLN.FIXED_QUANTITY FIXED_QUANTITY
, KLN.USAGE_DURATION USAGE_DURATION
, KLN.USAGE_PERIOD USAGE_PERIOD
, KLN.LEVEL_YN LEVEL_YN
, KLN.USAGE_TYPE USAGE_TYPE
, KLN.UOM_QUANTIFIED UOM_QUANTIFIED
, KLN.BASE_READING BASE_READING
, KLN.BILLING_SCHEDULE_TYPE BILLING_SCHEDULE_TYPE
, KLN.COVERAGE_TYPE COVERAGE_TYPE
, KLN.EXCEPTION_COV_ID EXCEPTION_COV_ID
, KLN.LIMIT_UOM_QUANTIFIED LIMIT_UOM_QUANTIFIED
, KLN.DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, KLN.DISCOUNT_PERCENT DISCOUNT_PERCENT
, KLN.OFFSET_DURATION OFFSET_DURATION
, KLN.OFFSET_PERIOD OFFSET_PERIOD
, KLN.INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, KLN.PDF_ID PDF_ID
, KLN.WORK_THRU_YN WORK_THRU_YN
, KLN.REACT_ACTIVE_YN REACT_ACTIVE_YN
, KLN.TRANSFER_OPTION TRANSFER_OPTION
, KLN.PROD_UPGRADE_YN PROD_UPGRADE_YN
, KLN.INHERITANCE_TYPE INHERITANCE_TYPE
, KLN.PM_PROGRAM_ID PM_PROGRAM_ID
, KLN.PM_CONF_REQ_YN PM_CONF_REQ_YN
, KLN.PM_SCH_EXISTS_YN PM_SCH_EXISTS_YN
, KLN.ALLOW_BT_DISCOUNT ALLOW_BT_DISCOUNT
, KLN.APPLY_DEFAULT_TIMEZONE APPLY_DEFAULT_TIMEZONE
, KLN.SYNC_DATE_INSTALL SYNC_DATE_INSTALL
, KLN.OBJECT_VERSION_NUMBER KLN_OBJECT_VERSION_NUMBER
, KLT.INVOICE_TEXT INVOICE_TEXT
, KLT.IB_TRX_DETAILS IB_TRX_DETAILS
, KLT.STATUS_TEXT STATUS_TEXT
, KLT.REACT_TIME_NAME REACT_TIME_NAME
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
, OKS_K_LINES_B KLN
, OKS_K_LINES_TL KLT
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND CLET.LANGUAGE = KLT.LANGUAGE
AND CLEB.ID = KLN.CLE_ID
AND KLN.ID = KLT.ID

Columns