VIEW: APPS.OKS_CONTRACT_UPD_DTLS_V

Source

View Text - Preformatted

SELECT oks_customer_acceptance_pvt.get_contract_customer(okchdrb.ID) AS customer, okchdrb.ID AS chr_id, DECODE (NVL (okchdrb.contract_number_modifier, 'X'),'X', okchdrb.contract_number, okchdrb.contract_number|| '-'|| okchdrb.contract_number_modifier) AS contract_number, vers.major_version || '.' || vers.minor_version AS VERSION, okchdrtl.cognomen AS known_as, okchdrtl.short_description AS description, prlst.NAME AS price_list, okchdrb.sts_code AS status_code, sts.meaning AS status_meaning, okchdrb.start_date AS start_date, okchdrb.end_date AS end_date, okshdrb.follow_up_date AS follow_up_due_date, okshdrb.follow_up_action AS follow_up_action, okc_util.decode_lookup('OKS_FOLLOWUP_ACTION',okshdrb.follow_up_action) AS followup_action_meaning, okshdrb.est_rev_percent AS estimation_percent, okshdrb.est_rev_date AS estimation_date, oks_misc_util_web.duration_period (okchdrb.start_date,okchdrb.end_date)|| ' '|| uom.unit_of_measure_tl AS DURATION, oks_customer_acceptance_pvt.get_contract_subtotal(okchdrb.ID) AS subtotal, oks_customer_acceptance_pvt.get_contract_tax (okchdrb.ID) AS tax, oks_customer_acceptance_pvt.get_contract_amount(okchdrb.ID) AS total_amount, negsts.meaning AS negotiation_status, cat.meaning AS category_meaning, prcagmt.NAME AS price_agreement, okchdrb.currency_code AS currency, NULL AS comments, NULL AS notestext, NULL AS newstatuscode, NULL AS newreasoncode, OKSHDRB.RENEWAL_COMMENT AS RENEWAL_COMMENT FROM okc_k_headers_all_b okchdrb, okc_k_headers_tl okchdrtl, oks_k_headers_b okshdrb, qp_list_headers_tl prlst, okc_statuses_b stsb, okc_statuses_tl sts, hr_all_organization_units_tl org, okc_subclasses_tl cat, okc_k_vers_numbers vers, okc_lookups_v negsts, fnd_currencies_tl currency, oe_agreements_tl prcagmt, okc_governances gov, mtl_units_of_measure_tl uom WHERE okchdrb.ID = okchdrtl.ID AND okchdrtl.LANGUAGE = USERENV ('LANG') AND okchdrb.ID = okshdrb.chr_id AND okchdrb.price_list_id = prlst.list_header_id(+) AND prlst.LANGUAGE(+) = USERENV ('LANG') AND okchdrb.sts_code = stsb.code AND stsb.code = sts.code AND sts.LANGUAGE = USERENV ('LANG') AND okchdrb.authoring_org_id = org.organization_id AND org.LANGUAGE = USERENV ('LANG') AND okchdrb.scs_code = cat.code AND cat.LANGUAGE = USERENV ('LANG') AND okchdrb.ID = vers.chr_id AND okshdrb.renewal_status = negsts.lookup_code(+) AND negsts.lookup_type(+) = 'OKS_AUTO_RENEW_STATUS' AND okchdrb.currency_code = currency.currency_code AND currency.LANGUAGE = USERENV ('LANG') AND okchdrb.ID = gov.dnz_chr_id(+) AND gov.cle_id(+) IS NULL AND gov.isa_agreement_id = prcagmt.agreement_id(+) AND prcagmt.LANGUAGE(+) = USERENV ('LANG') AND oks_misc_util_web.duration_unit (okchdrb.start_date, okchdrb.end_date) = uom.uom_code AND uom.LANGUAGE = USERENV ('LANG')

View Text - HTML Formatted

SELECT OKS_CUSTOMER_ACCEPTANCE_PVT.GET_CONTRACT_CUSTOMER(OKCHDRB.ID) AS CUSTOMER
, OKCHDRB.ID AS CHR_ID
, DECODE (NVL (OKCHDRB.CONTRACT_NUMBER_MODIFIER
, 'X')
, 'X'
, OKCHDRB.CONTRACT_NUMBER
, OKCHDRB.CONTRACT_NUMBER|| '-'|| OKCHDRB.CONTRACT_NUMBER_MODIFIER) AS CONTRACT_NUMBER
, VERS.MAJOR_VERSION || '.' || VERS.MINOR_VERSION AS VERSION
, OKCHDRTL.COGNOMEN AS KNOWN_AS
, OKCHDRTL.SHORT_DESCRIPTION AS DESCRIPTION
, PRLST.NAME AS PRICE_LIST
, OKCHDRB.STS_CODE AS STATUS_CODE
, STS.MEANING AS STATUS_MEANING
, OKCHDRB.START_DATE AS START_DATE
, OKCHDRB.END_DATE AS END_DATE
, OKSHDRB.FOLLOW_UP_DATE AS FOLLOW_UP_DUE_DATE
, OKSHDRB.FOLLOW_UP_ACTION AS FOLLOW_UP_ACTION
, OKC_UTIL.DECODE_LOOKUP('OKS_FOLLOWUP_ACTION'
, OKSHDRB.FOLLOW_UP_ACTION) AS FOLLOWUP_ACTION_MEANING
, OKSHDRB.EST_REV_PERCENT AS ESTIMATION_PERCENT
, OKSHDRB.EST_REV_DATE AS ESTIMATION_DATE
, OKS_MISC_UTIL_WEB.DURATION_PERIOD (OKCHDRB.START_DATE
, OKCHDRB.END_DATE)|| ' '|| UOM.UNIT_OF_MEASURE_TL AS DURATION
, OKS_CUSTOMER_ACCEPTANCE_PVT.GET_CONTRACT_SUBTOTAL(OKCHDRB.ID) AS SUBTOTAL
, OKS_CUSTOMER_ACCEPTANCE_PVT.GET_CONTRACT_TAX (OKCHDRB.ID) AS TAX
, OKS_CUSTOMER_ACCEPTANCE_PVT.GET_CONTRACT_AMOUNT(OKCHDRB.ID) AS TOTAL_AMOUNT
, NEGSTS.MEANING AS NEGOTIATION_STATUS
, CAT.MEANING AS CATEGORY_MEANING
, PRCAGMT.NAME AS PRICE_AGREEMENT
, OKCHDRB.CURRENCY_CODE AS CURRENCY
, NULL AS COMMENTS
, NULL AS NOTESTEXT
, NULL AS NEWSTATUSCODE
, NULL AS NEWREASONCODE
, OKSHDRB.RENEWAL_COMMENT AS RENEWAL_COMMENT
FROM OKC_K_HEADERS_ALL_B OKCHDRB
, OKC_K_HEADERS_TL OKCHDRTL
, OKS_K_HEADERS_B OKSHDRB
, QP_LIST_HEADERS_TL PRLST
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL STS
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, OKC_SUBCLASSES_TL CAT
, OKC_K_VERS_NUMBERS VERS
, OKC_LOOKUPS_V NEGSTS
, FND_CURRENCIES_TL CURRENCY
, OE_AGREEMENTS_TL PRCAGMT
, OKC_GOVERNANCES GOV
, MTL_UNITS_OF_MEASURE_TL UOM
WHERE OKCHDRB.ID = OKCHDRTL.ID
AND OKCHDRTL.LANGUAGE = USERENV ('LANG')
AND OKCHDRB.ID = OKSHDRB.CHR_ID
AND OKCHDRB.PRICE_LIST_ID = PRLST.LIST_HEADER_ID(+)
AND PRLST.LANGUAGE(+) = USERENV ('LANG')
AND OKCHDRB.STS_CODE = STSB.CODE
AND STSB.CODE = STS.CODE
AND STS.LANGUAGE = USERENV ('LANG')
AND OKCHDRB.AUTHORING_ORG_ID = ORG.ORGANIZATION_ID
AND ORG.LANGUAGE = USERENV ('LANG')
AND OKCHDRB.SCS_CODE = CAT.CODE
AND CAT.LANGUAGE = USERENV ('LANG')
AND OKCHDRB.ID = VERS.CHR_ID
AND OKSHDRB.RENEWAL_STATUS = NEGSTS.LOOKUP_CODE(+)
AND NEGSTS.LOOKUP_TYPE(+) = 'OKS_AUTO_RENEW_STATUS'
AND OKCHDRB.CURRENCY_CODE = CURRENCY.CURRENCY_CODE
AND CURRENCY.LANGUAGE = USERENV ('LANG')
AND OKCHDRB.ID = GOV.DNZ_CHR_ID(+)
AND GOV.CLE_ID(+) IS NULL
AND GOV.ISA_AGREEMENT_ID = PRCAGMT.AGREEMENT_ID(+)
AND PRCAGMT.LANGUAGE(+) = USERENV ('LANG')
AND OKS_MISC_UTIL_WEB.DURATION_UNIT (OKCHDRB.START_DATE
, OKCHDRB.END_DATE) = UOM.UOM_CODE
AND UOM.LANGUAGE = USERENV ('LANG')