Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_LA_SERVICE_LINES_UV |
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'