VIEW: APPS.OKI_EXPIRED_LINES_V

Source

View Text - Preformatted

SELECT cpl.cle_id contract_line_id , cpl.chr_id contract_id , cpl.contract_number , cpl.contract_number_modifier , cpl.complete_contract_number , cpl.scs_code , cpl.line_number , cpl.start_date , cpl.end_date , cpl.sts_code , sts.meaning status_meaning , cpl.trn_code , trn.meaning termination_meaning , cpl.date_terminated , cpl.date_renewed , cpl.end_period_num , cpl.end_period_name , cpl.end_quarter , cpl.end_year , cpl.unit_price , cpl.unit_price_percent , cpl.price_negotiated , cpl.currency_code , NULL price_negotiated_renewed , NULL currency_code_renewed , cpl.sob_price_unit , cpl.sob_price_negotiated , NULL sob_price_negotiated_renewed , cpl.sob_currency_code , cpl.base_price_unit , cpl.base_price_negotiated , NULL base_price_negotiated_renewed , cpl.base_currency_code , cpl.authoring_org_id , oin.name , cpl.inventory_organization_id , cpl.creation_date , cpl.last_update_date , cpl.attribute_category , cpl.attribute1 , cpl.attribute2 , cpl.attribute3 , cpl.attribute4 , cpl.attribute5 , cpl.attribute6 , cpl.attribute7 , cpl.attribute8 , cpl.attribute9 , cpl.attribute10 , cpl.attribute11 , cpl.attribute12 , cpl.attribute13 , cpl.attribute14 , cpl.attribute15 FROM OKI_COV_PRD_LINES CPL,FND_LOOKUPS TRN,OKC_STATUSES_V STS,HR_ALL_ORGANIZATION_UNITS_TL OIN WHERE sts.code = cpl.sts_code and trn.lookup_code(+) = cpl.trn_code and trn.lookup_type(+) = 'OKC_TERMINATION_REASON' and cpl.is_exp_not_renewed_yn = 'Y' and cpl.authoring_org_id = oin.organization_id and oin.language = userenv('LANG') and okc_util.get_k_access_level(cpl.chr_id, cpl.scs_code) in ('R','U')

View Text - HTML Formatted

SELECT CPL.CLE_ID CONTRACT_LINE_ID
, CPL.CHR_ID CONTRACT_ID
, CPL.CONTRACT_NUMBER
, CPL.CONTRACT_NUMBER_MODIFIER
, CPL.COMPLETE_CONTRACT_NUMBER
, CPL.SCS_CODE
, CPL.LINE_NUMBER
, CPL.START_DATE
, CPL.END_DATE
, CPL.STS_CODE
, STS.MEANING STATUS_MEANING
, CPL.TRN_CODE
, TRN.MEANING TERMINATION_MEANING
, CPL.DATE_TERMINATED
, CPL.DATE_RENEWED
, CPL.END_PERIOD_NUM
, CPL.END_PERIOD_NAME
, CPL.END_QUARTER
, CPL.END_YEAR
, CPL.UNIT_PRICE
, CPL.UNIT_PRICE_PERCENT
, CPL.PRICE_NEGOTIATED
, CPL.CURRENCY_CODE
, NULL PRICE_NEGOTIATED_RENEWED
, NULL CURRENCY_CODE_RENEWED
, CPL.SOB_PRICE_UNIT
, CPL.SOB_PRICE_NEGOTIATED
, NULL SOB_PRICE_NEGOTIATED_RENEWED
, CPL.SOB_CURRENCY_CODE
, CPL.BASE_PRICE_UNIT
, CPL.BASE_PRICE_NEGOTIATED
, NULL BASE_PRICE_NEGOTIATED_RENEWED
, CPL.BASE_CURRENCY_CODE
, CPL.AUTHORING_ORG_ID
, OIN.NAME
, CPL.INVENTORY_ORGANIZATION_ID
, CPL.CREATION_DATE
, CPL.LAST_UPDATE_DATE
, CPL.ATTRIBUTE_CATEGORY
, CPL.ATTRIBUTE1
, CPL.ATTRIBUTE2
, CPL.ATTRIBUTE3
, CPL.ATTRIBUTE4
, CPL.ATTRIBUTE5
, CPL.ATTRIBUTE6
, CPL.ATTRIBUTE7
, CPL.ATTRIBUTE8
, CPL.ATTRIBUTE9
, CPL.ATTRIBUTE10
, CPL.ATTRIBUTE11
, CPL.ATTRIBUTE12
, CPL.ATTRIBUTE13
, CPL.ATTRIBUTE14
, CPL.ATTRIBUTE15
FROM OKI_COV_PRD_LINES CPL
, FND_LOOKUPS TRN
, OKC_STATUSES_V STS
, HR_ALL_ORGANIZATION_UNITS_TL OIN
WHERE STS.CODE = CPL.STS_CODE
AND TRN.LOOKUP_CODE(+) = CPL.TRN_CODE
AND TRN.LOOKUP_TYPE(+) = 'OKC_TERMINATION_REASON'
AND CPL.IS_EXP_NOT_RENEWED_YN = 'Y'
AND CPL.AUTHORING_ORG_ID = OIN.ORGANIZATION_ID
AND OIN.LANGUAGE = USERENV('LANG')
AND OKC_UTIL.GET_K_ACCESS_LEVEL(CPL.CHR_ID
, CPL.SCS_CODE) IN ('R'
, 'U')