View: SO_LINE_SERVICE_DETAILS_V

View Text

SELECT LSD.ROWID ROW_ID
, LSD.LINE_SERVICE_DETAIL_ID
, LSD.CREATION_DATE
, LSD.CREATED_BY
, LSD.LAST_UPDATE_DATE
, LSD.LAST_UPDATED_BY
, LSD.LAST_UPDATE_LOGIN
, LSD.SOURCE_LINE_SERVICE_DETAIL_ID
, LSD.LINE_ID
, LSD.TRANSACTION_TYPE_ID
, LSD.SYSTEM_ID
, LSD.SYSTEM_TYPE_CODE
, LSD.CUSTOMER_PRODUCT_ID
, LSD.CUSTOMER_PRODUCT_TYPE_CODE
, LSD.CUSTOMER_PRODUCT_QUANTITY CP_QUANTITY
, LSD.CUSTOMER_PRODUCT_QUANTITY
, LSD.INSTALLATION_SITE_USE_ID
, LSD.TECHNICAL_CONTACT_ID
, LSD.SERVICE_ADMIN_CONTACT_ID
, LSD.CONTEXT
, LSD.ATTRIBUTE1
, LSD.ATTRIBUTE2
, LSD.ATTRIBUTE3
, LSD.ATTRIBUTE4
, LSD.ATTRIBUTE5
, LSD.ATTRIBUTE6
, LSD.ATTRIBUTE7
, LSD.ATTRIBUTE8
, LSD.ATTRIBUTE9
, LSD.ATTRIBUTE10
, LSD.ATTRIBUTE11
, LSD.ATTRIBUTE12
, LSD.ATTRIBUTE13
, LSD.ATTRIBUTE14
, LSD.ATTRIBUTE15
, LSD.TRANSACTION_TYPE_SVRID
, LSD.SYSTEM_SVRID
, LSD.SYSTEM_TYPE_SVRID
, LSD.CUSTOMER_PRODUCT_SVRID
, LSD.CUSTOMER_PRODUCT_TYPE_SVRID
, LSD.CP_QUANTITY_SVRID
, LSD.LOCATION_SVRID
, LSD.TECHNICAL_CONTACT_SVRID
, LSD.SERVICE_CONTACT_SVRID
, LSD.DF_SVRID
, TT.NAME TRANSACTION_TYPE
, TT.REVISION_FLAG
, CSLK.MEANING CUSTOMER_PRODUCT_TYPE
, SYS.NAME SYSTEM_NAME
, CSLK1.MEANING SYSTEM_TYPE
, CON.LAST_NAME || DECODE (CON.LAST_NAME
, NULL
, ' '
, '
, ') || CON.FIRST_NAME TECHNICAL_CONTACT
, CON1.LAST_NAME || DECODE (CON1.LAST_NAME
, NULL
, ' '
, '
, ') || CON1.FIRST_NAME SERVICE_CONTACT_NAME
, RACST.CUSTOMER_NAME
, RACST.CUSTOMER_NUMBER
, RASIT.LOCATION || DECODE (RASIT.LOCATION
, NULL
, ' '
, '; ') || RACST.CUSTOMER_NAME || DECODE (RACST.CUSTOMER_NAME
, NULL
, ' '
, '
, ') || RACST.CUSTOMER_NUMBER || DECODE (RACST.CUSTOMER_NUMBER
, NULL
, ' '
, '; ') || RAADR.ADDRESS1 || DECODE (RAADR.ADDRESS1
, NULL
, ' '
, '
, ') || RAADR.ADDRESS2 || DECODE (RAADR.ADDRESS2
, NULL
, ' '
, '
, ') || RAADR.ADDRESS3 || DECODE (RAADR.ADDRESS3
, NULL
, ' '
, '
, ') || RAADR.ADDRESS4 || DECODE (RAADR.ADDRESS4
, NULL
, ' '
, '
, ') || RAADR.CITY || DECODE (RAADR.CITY
, NULL
, ' '
, '
, ') || RAADR.STATE || ' ' || RAADR.POSTAL_CODE LOCATION
, CP.CURRENT_SERIAL_NUMBER CP_SERIAL_NUMBER
, CP.REFERENCE_NUMBER CP_REFERENCE_NUMBER
FROM SO_LINE_SERVICE_DETAILS LSD
, SO_LINES SOL
, CS_CUSTOMER_PRODUCTS CP
, CS_TRANSACTION_TYPES TT
, CS_SYSTEMS_VL SYS
, CS_LOOKUPS CSLK
, CS_LOOKUPS CSLK1
, RA_CONTACTS CON
, RA_CONTACTS CON1
, RA_SITE_USES RASIT
, RA_ADDRESSES RAADR
, RA_CUSTOMERS RACST
WHERE SOL.LINE_ID = LSD.LINE_ID (+)
AND LSD.TRANSACTION_TYPE_ID = TT.TRANSACTION_TYPE_ID
AND LSD.SYSTEM_ID = SYS.SYSTEM_ID (+)
AND SYS.SYSTEM_TYPE_CODE = CSLK1.LOOKUP_CODE (+)
AND CSLK1.LOOKUP_TYPE (+) = 'SYSTEM_TYPE'
AND LSD.CUSTOMER_PRODUCT_ID = CP.CUSTOMER_PRODUCT_ID (+)
AND LSD.CUSTOMER_PRODUCT_TYPE_CODE = CSLK.LOOKUP_CODE (+)
AND CSLK.LOOKUP_TYPE (+) = 'CUSTOMER_PRODUCT_TYPE'
AND LSD.TECHNICAL_CONTACT_ID = CON.CONTACT_ID (+)
AND LSD.SERVICE_ADMIN_CONTACT_ID = CON1.CONTACT_ID (+)
AND LSD.INSTALLATION_SITE_USE_ID = RASIT.SITE_USE_ID (+)
AND RAADR.ADDRESS_ID (+) = RASIT.ADDRESS_ID
AND RACST.CUSTOMER_ID (+) = RAADR.CUSTOMER_ID

Columns