View: OKS_AUTH_SHOWALL_PROD_V

Product:	OKS - Service Contracts
Description:
Implementation/DBA Data:	APPS.OKS_AUTH_SHOWALL_PROD_V

View Text

SELECT TO_NUMBER(KLIN.LINE_NUMBER)
, KLIN.START_DATE
, KLIN.END_DATE
, OKS_EXTWAR_UTIL_PVT.ROUND_CURRENCY_AMT(KLIN.PRICE_NEGOTIATED
, KHDR.CURRENCY_CODE)
, KLIN.ID
, KLIN.CLE_ID
, DECODE(FND_PROFILE.VALUE('OKS_ITEM_DISPLAY_PREFERENCE')
, 'DISPLAY_NAME'
, OKS_AUTH_UTIL_PVT.GET_ITEM_DESC(CII.INVENTORY_ITEM_ID)
, OKS_AUTH_UTIL_PVT.GET_ITEM_NAME(CII.INVENTORY_ITEM_ID)) PRODUCT_NAME
, CII.SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, PSITE.DESCRIPTION ADDRESS
, CII.INSTALL_DATE INSTALLATION_DATE
, CII.QUANTITY QUANTITY
, CII.UNIT_OF_MEASURE UOM_CODE
, CII.INSTANCE_NUMBER REFERENCE_NUMBER
, OOL.UNIT_SELLING_PRICE NET_AMOUNT
, CII.INSTANCE_ID CUSTOMER_PRODUCT_ID
, CST.NAME CSI_NUMBER
, ACCT.NAME CUSTOMER_NAME
, CIPA.PRICING_ATTRIBUTE1
, CIPA.PRICING_ATTRIBUTE2
, CIPA.PRICING_ATTRIBUTE3
, CIPA.PRICING_ATTRIBUTE4
, CIPA.PRICING_ATTRIBUTE5
, CIPA.PRICING_ATTRIBUTE6
, CIPA.PRICING_ATTRIBUTE7
, CIPA.PRICING_ATTRIBUTE8
, CIPA.PRICING_ATTRIBUTE9
, CIPA.PRICING_ATTRIBUTE10
, CIPA.PRICING_ATTRIBUTE11
, CIPA.PRICING_ATTRIBUTE12
, CIPA.PRICING_ATTRIBUTE13
, CIPA.PRICING_ATTRIBUTE14
, CIPA.PRICING_ATTRIBUTE15
, CIPA.PRICING_ATTRIBUTE16
, CIPA.PRICING_ATTRIBUTE17
, CIPA.PRICING_ATTRIBUTE18
, CIPA.PRICING_ATTRIBUTE19
, CIPA.PRICING_ATTRIBUTE20
, CIPA.PRICING_ATTRIBUTE21
, CIPA.PRICING_ATTRIBUTE22
, CIPA.PRICING_ATTRIBUTE23
, CIPA.PRICING_ATTRIBUTE24
, CIPA.PRICING_ATTRIBUTE25
, CIPA.PRICING_ATTRIBUTE26
, CIPA.PRICING_ATTRIBUTE27
, CIPA.PRICING_ATTRIBUTE28
, CIPA.PRICING_ATTRIBUTE29
, CIPA.PRICING_ATTRIBUTE30
, CIPA.PRICING_ATTRIBUTE31
, CIPA.PRICING_ATTRIBUTE32
, CIPA.PRICING_ATTRIBUTE33
, CIPA.PRICING_ATTRIBUTE34
, CIPA.PRICING_ATTRIBUTE35
, CIPA.PRICING_ATTRIBUTE36
, CIPA.PRICING_ATTRIBUTE37
, CIPA.PRICING_ATTRIBUTE38
, CIPA.PRICING_ATTRIBUTE39
, CIPA.PRICING_ATTRIBUTE40
, CIPA.PRICING_ATTRIBUTE41
, CIPA.PRICING_ATTRIBUTE42
, CIPA.PRICING_ATTRIBUTE43
, CIPA.PRICING_ATTRIBUTE44
, CIPA.PRICING_ATTRIBUTE45
, CIPA.PRICING_ATTRIBUTE46
, CIPA.PRICING_ATTRIBUTE47
, CIPA.PRICING_ATTRIBUTE48
, CIPA.PRICING_ATTRIBUTE49
, CIPA.PRICING_ATTRIBUTE50
, CIPA.PRICING_ATTRIBUTE51
, CIPA.PRICING_ATTRIBUTE52
, CIPA.PRICING_ATTRIBUTE53
, CIPA.PRICING_ATTRIBUTE54
, CIPA.PRICING_ATTRIBUTE55
, CIPA.PRICING_ATTRIBUTE56
, CIPA.PRICING_ATTRIBUTE57
, CIPA.PRICING_ATTRIBUTE58
, CIPA.PRICING_ATTRIBUTE59
, CIPA.PRICING_ATTRIBUTE60
, CIPA.PRICING_ATTRIBUTE61
, CIPA.PRICING_ATTRIBUTE62
, CIPA.PRICING_ATTRIBUTE63
, CIPA.PRICING_ATTRIBUTE64
, CIPA.PRICING_ATTRIBUTE65
, CIPA.PRICING_ATTRIBUTE66
, CIPA.PRICING_ATTRIBUTE67
, CIPA.PRICING_ATTRIBUTE68
, CIPA.PRICING_ATTRIBUTE69
, CIPA.PRICING_ATTRIBUTE70
, CIPA.PRICING_ATTRIBUTE71
, CIPA.PRICING_ATTRIBUTE72
, CIPA.PRICING_ATTRIBUTE73
, CIPA.PRICING_ATTRIBUTE74
, CIPA.PRICING_ATTRIBUTE75
, CIPA.PRICING_ATTRIBUTE76
, CIPA.PRICING_ATTRIBUTE77
, CIPA.PRICING_ATTRIBUTE78
, CIPA.PRICING_ATTRIBUTE79
, CIPA.PRICING_ATTRIBUTE80
, CIPA.PRICING_ATTRIBUTE81
, CIPA.PRICING_ATTRIBUTE82
, CIPA.PRICING_ATTRIBUTE83
, CIPA.PRICING_ATTRIBUTE84
, CIPA.PRICING_ATTRIBUTE85
, CIPA.PRICING_ATTRIBUTE86
, CIPA.PRICING_ATTRIBUTE87
, CIPA.PRICING_ATTRIBUTE88
, CIPA.PRICING_ATTRIBUTE89
, CIPA.PRICING_ATTRIBUTE90
, CIPA.PRICING_ATTRIBUTE91
, CIPA.PRICING_ATTRIBUTE92
, CIPA.PRICING_ATTRIBUTE93
, CIPA.PRICING_ATTRIBUTE94
, CIPA.PRICING_ATTRIBUTE95
, CIPA.PRICING_ATTRIBUTE96
, CIPA.PRICING_ATTRIBUTE97
, CIPA.PRICING_ATTRIBUTE98
, CIPA.PRICING_ATTRIBUTE99
, CIPA.PRICING_ATTRIBUTE100
, CIPA.PRICING_CONTEXT
FROM CSI_ITEM_INSTANCES CII
, CSI_I_PRICING_ATTRIBS CIPA
, OE_ORDER_LINES_ALL OOL
, OKX_PARTY_SITES_V PSITE
, CSI_SYSTEMS_B SYST
, CSI_SYSTEMS_TL CST
, OKX_CUSTOMER_ACCOUNTS_V ACCT
, OKC_K_HEADERS_B KHDR
, OKC_K_LINES_B KLIN
, OKC_K_ITEMS KITM
WHERE CIPA.INSTANCE_ID(+) = CII.INSTANCE_ID
AND CII.OWNER_PARTY_ACCOUNT_ID = ACCT.ID1
AND CII.INSTALL_LOCATION_ID = PSITE.ID1(+)
AND CII.SYSTEM_ID = SYST.SYSTEM_ID(+)
AND SYST.SYSTEM_ID = CST.SYSTEM_ID (+)
AND CII.LAST_OE_ORDER_LINE_ID = OOL.LINE_ID (+)
AND KHDR.ID = KLIN.DNZ_CHR_ID
AND KLIN.CLE_ID IS NOT NULL
AND KLIN.ID = KITM.CLE_ID
AND KITM.OBJECT1_ID1 = CII.INSTANCE_ID
AND KITM.OBJECT1_ID2 = '#'
AND KITM.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'
AND CST.LANGUAGE(+) = USERENV('LANG')

Columns