VIEW: APPS.OKL_LA_SERVICE_LINES_UV

Source

View Text - Preformatted

SELECT to_char(cleb_svc.id) cleb_svc_id, to_char(cleb_svc.dnz_chr_id) dnz_chr_id, to_char(cim_svc.id) cim_svc_id, msit.description cim_svc_name, cim_svc.object1_id1 cim_svc_object1_id1, cim_svc.object1_id2 cim_svc_object1_id2, cim_svc.jtot_object1_code cim_svc_object1_code, cleb_svc.start_date, cleb_svc.end_date, kle_svc.amount amount, kle_svc.attribute_category, kle_svc.attribute1, kle_svc.attribute2, kle_svc.attribute3, kle_svc.attribute4, kle_svc.attribute5, kle_svc.attribute6, kle_svc.attribute7, kle_svc.attribute8, kle_svc.attribute9, kle_svc.attribute10, kle_svc.attribute11, kle_svc.attribute12, kle_svc.attribute13, kle_svc.attribute14, kle_svc.attribute15, rgp_lafexp.id rgp_lafexp_id, rul_lafreq.id rul_lafreq_id, rul_lafreq.object1_id1 rul_lafreq_object1_id1, rul_lafreq.object1_id2 rul_lafreq_object1_id2, rul_lafreq.jtot_object1_code rul_lafreq_object1_code, tuom.name frequency_name, rul_lafexp.id rul_lafexp_id, rul_lafexp.rule_information1, rul_lafexp.rule_information2, to_char(lnstyle.id) FROM OKC_K_LINES_B CLEB_SVC,OKL_K_LINES KLE_SVC,OKC_K_ITEMS CIM_SVC,MTL_SYSTEM_ITEMS_TL MSIT,OKC_RULE_GROUPS_B RGP_LAFEXP,OKC_RULES_B RUL_LAFREQ,OKC_RULES_B RUL_LAFEXP,OKL_TIME_UNITS_V TUOM,OKC_LINE_STYLES_B LNSTYLE WHERE cleb_svc.id = kle_svc.id AND cim_svc.cle_id = cleb_svc.id AND cim_svc.dnz_chr_id = cleb_svc.dnz_chr_id AND cim_svc.jtot_object1_code = 'OKX_SERVICE' AND msit.inventory_item_id = cim_svc.object1_id1 AND msit.organization_id = cim_svc.object1_id2 AND msit.language = USERENV('LANG') AND rgp_lafexp.dnz_chr_id (+) = cleb_svc.dnz_chr_id AND rgp_lafexp.cle_id (+) = cleb_svc.id AND rgp_lafexp.rgd_code (+) = 'LAFEXP' AND rul_lafreq.rgp_id (+) = rgp_lafexp.id AND rul_lafreq.rule_information_category (+) = 'LAFREQ' AND rul_lafexp.rgp_id (+) = rgp_lafexp.id AND rul_lafexp.rule_information_category (+) = 'LAFEXP' AND tuom.id1 (+) = rul_lafreq.object1_id1 AND LTY_CODE='SOLD_SERVICE'

View Text - HTML Formatted

SELECT TO_CHAR(CLEB_SVC.ID) CLEB_SVC_ID
, TO_CHAR(CLEB_SVC.DNZ_CHR_ID) DNZ_CHR_ID
, TO_CHAR(CIM_SVC.ID) CIM_SVC_ID
, MSIT.DESCRIPTION CIM_SVC_NAME
, CIM_SVC.OBJECT1_ID1 CIM_SVC_OBJECT1_ID1
, CIM_SVC.OBJECT1_ID2 CIM_SVC_OBJECT1_ID2
, CIM_SVC.JTOT_OBJECT1_CODE CIM_SVC_OBJECT1_CODE
, CLEB_SVC.START_DATE
, CLEB_SVC.END_DATE
, KLE_SVC.AMOUNT AMOUNT
, KLE_SVC.ATTRIBUTE_CATEGORY
, KLE_SVC.ATTRIBUTE1
, KLE_SVC.ATTRIBUTE2
, KLE_SVC.ATTRIBUTE3
, KLE_SVC.ATTRIBUTE4
, KLE_SVC.ATTRIBUTE5
, KLE_SVC.ATTRIBUTE6
, KLE_SVC.ATTRIBUTE7
, KLE_SVC.ATTRIBUTE8
, KLE_SVC.ATTRIBUTE9
, KLE_SVC.ATTRIBUTE10
, KLE_SVC.ATTRIBUTE11
, KLE_SVC.ATTRIBUTE12
, KLE_SVC.ATTRIBUTE13
, KLE_SVC.ATTRIBUTE14
, KLE_SVC.ATTRIBUTE15
, RGP_LAFEXP.ID RGP_LAFEXP_ID
, RUL_LAFREQ.ID RUL_LAFREQ_ID
, RUL_LAFREQ.OBJECT1_ID1 RUL_LAFREQ_OBJECT1_ID1
, RUL_LAFREQ.OBJECT1_ID2 RUL_LAFREQ_OBJECT1_ID2
, RUL_LAFREQ.JTOT_OBJECT1_CODE RUL_LAFREQ_OBJECT1_CODE
, TUOM.NAME FREQUENCY_NAME
, RUL_LAFEXP.ID RUL_LAFEXP_ID
, RUL_LAFEXP.RULE_INFORMATION1
, RUL_LAFEXP.RULE_INFORMATION2
, TO_CHAR(LNSTYLE.ID)
FROM OKC_K_LINES_B CLEB_SVC
, OKL_K_LINES KLE_SVC
, OKC_K_ITEMS CIM_SVC
, MTL_SYSTEM_ITEMS_TL MSIT
, OKC_RULE_GROUPS_B RGP_LAFEXP
, OKC_RULES_B RUL_LAFREQ
, OKC_RULES_B RUL_LAFEXP
, OKL_TIME_UNITS_V TUOM
, OKC_LINE_STYLES_B LNSTYLE
WHERE CLEB_SVC.ID = KLE_SVC.ID
AND CIM_SVC.CLE_ID = CLEB_SVC.ID
AND CIM_SVC.DNZ_CHR_ID = CLEB_SVC.DNZ_CHR_ID
AND CIM_SVC.JTOT_OBJECT1_CODE = 'OKX_SERVICE'
AND MSIT.INVENTORY_ITEM_ID = CIM_SVC.OBJECT1_ID1
AND MSIT.ORGANIZATION_ID = CIM_SVC.OBJECT1_ID2
AND MSIT.LANGUAGE = USERENV('LANG')
AND RGP_LAFEXP.DNZ_CHR_ID (+) = CLEB_SVC.DNZ_CHR_ID
AND RGP_LAFEXP.CLE_ID (+) = CLEB_SVC.ID
AND RGP_LAFEXP.RGD_CODE (+) = 'LAFEXP'
AND RUL_LAFREQ.RGP_ID (+) = RGP_LAFEXP.ID
AND RUL_LAFREQ.RULE_INFORMATION_CATEGORY (+) = 'LAFREQ'
AND RUL_LAFEXP.RGP_ID (+) = RGP_LAFEXP.ID
AND RUL_LAFEXP.RULE_INFORMATION_CATEGORY (+) = 'LAFEXP'
AND TUOM.ID1 (+) = RUL_LAFREQ.OBJECT1_ID1
AND LTY_CODE='SOLD_SERVICE'