FND Design Data [Home] [Help]

View: OKL_LA_LINK_SERVICE_UV

Product: OKL - Lease and Finance Management
Description: OKL Link Service Line LOV View
Implementation/DBA Data: ViewAPPS.OKL_LA_LINK_SERVICE_UV
View Text

SELECT CHR.ID CHR_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR_TL.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHR.CURRENCY_CODE CURRENCY_CODE
, CHR.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHR.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, PARTY.PARTY_ID CUSTOMER_ID
, PARTY.PARTY_NUMBER CUSTOMER_NUMBER
, PARTY.PARTY_NAME CUSTOMER_NAME
, CLE.ID CLE_ID
, STYLE.LTY_CODE LTY_CODE
, SRV_MTL.SEGMENT1 ITEM_NAME
, SRV_MTL.DESCRIPTION ITEM_DESCRIPTION
, ITEM.OBJECT1_ID1 ITEM_ID
, CLE.START_DATE START_DATE
, CLE.END_DATE END_DATE
, CHR.BILL_TO_SITE_USE_ID
, CS_PROD.INVENTORY_ITEM_ID COVERED_ITEM_ID
, COV_MTL.SEGMENT1 COVERED_ITEM_NAME
, COV_MTL.DESCRIPTION COVERED_ITEM_DESCRIPTION
FROM OKC_K_HEADERS_B CHR
, OKC_K_HEADERS_TL CHR_TL
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL CLE_TL
, OKC_LINE_STYLES_B STYLE
, OKC_K_ITEMS ITEM
, MTL_SYSTEM_ITEMS_B SRV_MTL
, OKC_K_PARTY_ROLES_B ROLE
, HZ_PARTIES PARTY
, OKC_K_LINES_B COV_LINE
, OKC_LINE_STYLES_B COV_STYLE
, OKC_K_ITEMS COV_ITEM
, CSI_ITEM_INSTANCES CS_PROD
, MTL_SYSTEM_ITEMS_B COV_MTL
WHERE CHR.ID = CLE.CHR_ID
AND CHR.ID = CHR_TL.ID
AND CLE.ID = CLE_TL.ID
AND CLE.LSE_ID = STYLE.ID
AND ITEM.CLE_ID = CLE.ID
AND ITEM.DNZ_CHR_ID = CHR.ID
AND ITEM.OBJECT1_ID1 = SRV_MTL.INVENTORY_ITEM_ID
AND ITEM.OBJECT1_ID2 = TO_CHAR( SRV_MTL.ORGANIZATION_ID)
AND ROLE.OBJECT1_ID1 = PARTY.PARTY_ID
AND CHR.ID = ROLE.CHR_ID
AND ROLE.RLE_CODE = 'CUSTOMER'
AND STYLE.LTY_CODE = 'SERVICE'
AND CHR.STS_CODE = 'ACTIVE'
AND CLE.STS_CODE = 'ACTIVE'
AND CHR_TL.LANGUAGE = USERENV('LANG')
AND CLE_TL.LANGUAGE = USERENV('LANG')
AND COV_LINE.CLE_ID = CLE.ID
AND COV_LINE.DNZ_CHR_ID = CHR.ID
AND COV_LINE.LSE_ID = COV_STYLE.ID
AND COV_STYLE.LTY_CODE = 'COVER_PROD'
AND COV_LINE.ID = COV_ITEM.CLE_ID
AND COV_ITEM.OBJECT1_ID1 = CS_PROD.INSTANCE_ID
AND CS_PROD.INVENTORY_ITEM_ID = COV_MTL.INVENTORY_ITEM_ID
AND COV_MTL.ORGANIZATION_ID = CHR.INV_ORGANIZATION_ID

Columns

Name
CHR_ID
CONTRACT_NUMBER
SHORT_DESCRIPTION
CURRENCY_CODE
AUTHORING_ORG_ID
INV_ORGANIZATION_ID
CUSTOMER_ID
CUSTOMER_NUMBER
CUSTOMER_NAME
CLE_ID
LTY_CODE
ITEM_NAME
ITEM_DESCRIPTION
ITEM_ID
START_DATE
END_DATE
BILL_TO_ID
COVERED_ITEM_ID
COVERED_ITEM_NAME
COVERED_ITEM_DESCRIPTION