VIEW: CS.CS_CP_SERVICES_ALL#

Source

View Text - Preformatted

select CP_SERVICE_ID CP_SERVICE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID, SERVICE_MANUFACTURING_ORG_ID SERVICE_MANUFACTURING_ORG_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, STATUS_CODE STATUS_CODE, LAST_CP_SERVICE_TRANSACTION_ID LAST_CP_SERVICE_TRANSACTION_ID, INVOICE_FLAG INVOICE_FLAG, COVERAGE_SCHEDULE_ID COVERAGE_SCHEDULE_ID, PRORATE_FLAG PRORATE_FLAG, DURATION_QUANTITY DURATION_QUANTITY, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE, STARTING_DELAY STARTING_DELAY, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID, SERVICE_TXN_AVAILABILITY_CODE SERVICE_TXN_AVAILABILITY_CODE, NEXT_PM_VISIT_DATE NEXT_PM_VISIT_DATE, PM_VISITS_COMPLETED PM_VISITS_COMPLETED, LAST_PM_VISIT_DATE LAST_PM_VISIT_DATE, PM_SCHEDULE_ID PM_SCHEDULE_ID, PM_SCHEDULE_FLAG PM_SCHEDULE_FLAG, CURRENT_MAX_SCHEDULE_DATE CURRENT_MAX_SCHEDULE_DATE, PRICE_LIST_ID PRICE_LIST_ID, PRICING_ATTRIBUTE1 PRICING_ATTRIBUTE1, PRICING_ATTRIBUTE2 PRICING_ATTRIBUTE2, PRICING_ATTRIBUTE3 PRICING_ATTRIBUTE3, PRICING_ATTRIBUTE4 PRICING_ATTRIBUTE4, PRICING_ATTRIBUTE5 PRICING_ATTRIBUTE5, PRICING_ATTRIBUTE6 PRICING_ATTRIBUTE6, PRICING_ATTRIBUTE7 PRICING_ATTRIBUTE7, PRICING_ATTRIBUTE8 PRICING_ATTRIBUTE8, PRICING_ATTRIBUTE9 PRICING_ATTRIBUTE9, PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE10, PRICING_ATTRIBUTE11 PRICING_ATTRIBUTE11, PRICING_ATTRIBUTE12 PRICING_ATTRIBUTE12, PRICING_ATTRIBUTE13 PRICING_ATTRIBUTE13, PRICING_ATTRIBUTE14 PRICING_ATTRIBUTE14, PRICING_ATTRIBUTE15 PRICING_ATTRIBUTE15, PRICING_CONTEXT PRICING_CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CONTEXT CONTEXT, SERVICE_ORDER_TYPE SERVICE_ORDER_TYPE, INVOICE_COUNT INVOICE_COUNT, CURRENCY_CODE CURRENCY_CODE, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, ORIGINAL_SERVICE_LINE_ID ORIGINAL_SERVICE_LINE_ID, WARRANTY_FLAG WARRANTY_FLAG, ORG_ID ORG_ID, ORIGINAL_START_DATE ORIGINAL_START_DATE, ORIGINAL_END_DATE ORIGINAL_END_DATE, SERVICE_DATE_CHANGE SERVICE_DATE_CHANGE, CONTRACT_ID CONTRACT_ID, WORKFLOW WORKFLOW, CONTRACT_LINE_STATUS_ID CONTRACT_LINE_STATUS_ID, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, EXTENDED_PRICE EXTENDED_PRICE, DISCOUNT_ID DISCOUNT_ID, TAX_CODE TAX_CODE, BILLING_FREQUENCY_PERIOD BILLING_FREQUENCY_PERIOD, FIRST_BILL_DATE FIRST_BILL_DATE, NEXT_BILL_DATE NEXT_BILL_DATE, BILL_ON BILL_ON, LIST_PRICE LIST_PRICE, PRICE_PERCENT PRICE_PERCENT, CONTRACT_LINE_TEMPLATE_ID CONTRACT_LINE_TEMPLATE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID from "CS"."CS_CP_SERVICES_ALL"

View Text - HTML Formatted

SELECT CP_SERVICE_ID CP_SERVICE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID
, SERVICE_MANUFACTURING_ORG_ID SERVICE_MANUFACTURING_ORG_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, STATUS_CODE STATUS_CODE
, LAST_CP_SERVICE_TRANSACTION_ID LAST_CP_SERVICE_TRANSACTION_ID
, INVOICE_FLAG INVOICE_FLAG
, COVERAGE_SCHEDULE_ID COVERAGE_SCHEDULE_ID
, PRORATE_FLAG PRORATE_FLAG
, DURATION_QUANTITY DURATION_QUANTITY
, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE
, STARTING_DELAY STARTING_DELAY
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, SERVICE_TXN_AVAILABILITY_CODE SERVICE_TXN_AVAILABILITY_CODE
, NEXT_PM_VISIT_DATE NEXT_PM_VISIT_DATE
, PM_VISITS_COMPLETED PM_VISITS_COMPLETED
, LAST_PM_VISIT_DATE LAST_PM_VISIT_DATE
, PM_SCHEDULE_ID PM_SCHEDULE_ID
, PM_SCHEDULE_FLAG PM_SCHEDULE_FLAG
, CURRENT_MAX_SCHEDULE_DATE CURRENT_MAX_SCHEDULE_DATE
, PRICE_LIST_ID PRICE_LIST_ID
, PRICING_ATTRIBUTE1 PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2 PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3 PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4 PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5 PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6 PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7 PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8 PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9 PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11 PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12 PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13 PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14 PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15 PRICING_ATTRIBUTE15
, PRICING_CONTEXT PRICING_CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CONTEXT CONTEXT
, SERVICE_ORDER_TYPE SERVICE_ORDER_TYPE
, INVOICE_COUNT INVOICE_COUNT
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, ORIGINAL_SERVICE_LINE_ID ORIGINAL_SERVICE_LINE_ID
, WARRANTY_FLAG WARRANTY_FLAG
, ORG_ID ORG_ID
, ORIGINAL_START_DATE ORIGINAL_START_DATE
, ORIGINAL_END_DATE ORIGINAL_END_DATE
, SERVICE_DATE_CHANGE SERVICE_DATE_CHANGE
, CONTRACT_ID CONTRACT_ID
, WORKFLOW WORKFLOW
, CONTRACT_LINE_STATUS_ID CONTRACT_LINE_STATUS_ID
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, EXTENDED_PRICE EXTENDED_PRICE
, DISCOUNT_ID DISCOUNT_ID
, TAX_CODE TAX_CODE
, BILLING_FREQUENCY_PERIOD BILLING_FREQUENCY_PERIOD
, FIRST_BILL_DATE FIRST_BILL_DATE
, NEXT_BILL_DATE NEXT_BILL_DATE
, BILL_ON BILL_ON
, LIST_PRICE LIST_PRICE
, PRICE_PERCENT PRICE_PERCENT
, CONTRACT_LINE_TEMPLATE_ID CONTRACT_LINE_TEMPLATE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
FROM "CS"."CS_CP_SERVICES_ALL"