VIEW: APPS.CS_SERVICE_COVERAGES_V

Source

View Text - Preformatted

SELECT COV.COVERAGE_ID , COV.LAST_UPDATE_DATE , COV.LAST_UPDATED_BY , COV.CREATION_DATE , COV.CREATED_BY , COV.LAST_UPDATE_LOGIN , COV.NAME , COV.DESCRIPTION , COV.START_DATE_ACTIVE , COV.END_DATE_ACTIVE , COV.COVERAGE_LEVEL , COV.TIME_BILLABLE_PERCENT , COV.MAX_TIME_BILLABLE_AMOUNT , COV.MATERIAL_BILLABLE_PERCENT , COV.MAX_MATERIAL_BILLABLE_AMOUNT , COV.EXPENSE_BILLABLE_PERCENT , COV.MAX_EXPENSE_BILLABLE_AMOUNT , COV.MAX_COVERAGE_AMOUNT , COV.RESPONSE_TIME_PERIOD_CODE , COV.RESPONSE_TIME_VALUE , COV.SUNDAY_START_TIME , COV.SUNDAY_END_TIME , COV.MONDAY_START_TIME , COV.MONDAY_END_TIME , COV.TUESDAY_START_TIME , COV.TUESDAY_END_TIME , COV.WEDNESDAY_START_TIME , COV.WEDNESDAY_END_TIME , COV.THURSDAY_START_TIME , COV.THURSDAY_END_TIME , COV.FRIDAY_START_TIME , COV.FRIDAY_END_TIME , COV.SATURDAY_START_TIME , COV.SATURDAY_END_TIME , COV.ATTRIBUTE1 , COV.ATTRIBUTE2 , COV.ATTRIBUTE3 , COV.ATTRIBUTE4 , COV.ATTRIBUTE5 , COV.ATTRIBUTE6 , COV.ATTRIBUTE7 , COV.ATTRIBUTE8 , COV.ATTRIBUTE9 , COV.ATTRIBUTE10 , COV.CONTEXT , CPS.CP_SERVICE_ID , CPS.SERVICE_INVENTORY_ITEM_ID , CPS.CUSTOMER_PRODUCT_ID , CPS.START_DATE_ACTIVE SERVICE_START , CPS.END_DATE_ACTIVE SERVICE_END , MTL.CONCATENATED_SEGMENTS SERVICE_NAME , MTL.DESCRIPTION SERVICE_DESCRIPTION , MTL.VENDOR_WARRANTY_FLAG WARRANTY_FLAG , CP.INVENTORY_ITEM_ID , CP.REFERENCE_NUMBER , CP.CUSTOMER_ID FROM CS_CUSTOMER_PRODUCTS CP ,MTL_SYSTEM_ITEMS_KFV MTL ,CS_COVERAGES COV ,CS_CP_SERVICES CPS WHERE CPS.CUSTOMER_PRODUCT_ID = CP.CUSTOMER_PRODUCT_ID AND CPS.SERVICE_INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND CPS.COVERAGE_SCHEDULE_ID = COV.COVERAGE_ID (+) AND MTL.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID'))

View Text - HTML Formatted

SELECT COV.COVERAGE_ID
, COV.LAST_UPDATE_DATE
, COV.LAST_UPDATED_BY
, COV.CREATION_DATE
, COV.CREATED_BY
, COV.LAST_UPDATE_LOGIN
, COV.NAME
, COV.DESCRIPTION
, COV.START_DATE_ACTIVE
, COV.END_DATE_ACTIVE
, COV.COVERAGE_LEVEL
, COV.TIME_BILLABLE_PERCENT
, COV.MAX_TIME_BILLABLE_AMOUNT
, COV.MATERIAL_BILLABLE_PERCENT
, COV.MAX_MATERIAL_BILLABLE_AMOUNT
, COV.EXPENSE_BILLABLE_PERCENT
, COV.MAX_EXPENSE_BILLABLE_AMOUNT
, COV.MAX_COVERAGE_AMOUNT
, COV.RESPONSE_TIME_PERIOD_CODE
, COV.RESPONSE_TIME_VALUE
, COV.SUNDAY_START_TIME
, COV.SUNDAY_END_TIME
, COV.MONDAY_START_TIME
, COV.MONDAY_END_TIME
, COV.TUESDAY_START_TIME
, COV.TUESDAY_END_TIME
, COV.WEDNESDAY_START_TIME
, COV.WEDNESDAY_END_TIME
, COV.THURSDAY_START_TIME
, COV.THURSDAY_END_TIME
, COV.FRIDAY_START_TIME
, COV.FRIDAY_END_TIME
, COV.SATURDAY_START_TIME
, COV.SATURDAY_END_TIME
, COV.ATTRIBUTE1
, COV.ATTRIBUTE2
, COV.ATTRIBUTE3
, COV.ATTRIBUTE4
, COV.ATTRIBUTE5
, COV.ATTRIBUTE6
, COV.ATTRIBUTE7
, COV.ATTRIBUTE8
, COV.ATTRIBUTE9
, COV.ATTRIBUTE10
, COV.CONTEXT
, CPS.CP_SERVICE_ID
, CPS.SERVICE_INVENTORY_ITEM_ID
, CPS.CUSTOMER_PRODUCT_ID
, CPS.START_DATE_ACTIVE SERVICE_START
, CPS.END_DATE_ACTIVE SERVICE_END
, MTL.CONCATENATED_SEGMENTS SERVICE_NAME
, MTL.DESCRIPTION SERVICE_DESCRIPTION
, MTL.VENDOR_WARRANTY_FLAG WARRANTY_FLAG
, CP.INVENTORY_ITEM_ID
, CP.REFERENCE_NUMBER
, CP.CUSTOMER_ID
FROM CS_CUSTOMER_PRODUCTS CP
, MTL_SYSTEM_ITEMS_KFV MTL
, CS_COVERAGES COV
, CS_CP_SERVICES CPS
WHERE CPS.CUSTOMER_PRODUCT_ID = CP.CUSTOMER_PRODUCT_ID
AND CPS.SERVICE_INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND CPS.COVERAGE_SCHEDULE_ID = COV.COVERAGE_ID (+)
AND MTL.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID'))