DBA Data[Home] [Help] [Dependency Information]

TABLE: CS.CS_CP_SERVICES_ALL

Object Details
Object Name: CS_CP_SERVICES_ALL
Object Type: TABLE
Owner: CS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CS_CP_SERVICES_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCP_SERVICE_ID
CS_CP_SERVICES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSERVICE_INVENTORY_ITEM_ID
CS_CP_SERVICES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCUSTOMER_PRODUCT_ID
CS_CP_SERVICES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSTATUS_CODE
Columns
Name Datatype Length Mandatory Comments
CP_SERVICE_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CUSTOMER_PRODUCT_ID NUMBER (15)
SERVICE_INVENTORY_ITEM_ID NUMBER (15) Yes
SERVICE_MANUFACTURING_ORG_ID NUMBER (15) Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

STATUS_CODE VARCHAR2 (30)
LAST_CP_SERVICE_TRANSACTION_ID NUMBER (15)
INVOICE_FLAG VARCHAR2 (1)
COVERAGE_SCHEDULE_ID NUMBER (15)
PRORATE_FLAG VARCHAR2 (1)
DURATION_QUANTITY NUMBER (38)
UNIT_OF_MEASURE_CODE VARCHAR2 (30)
STARTING_DELAY NUMBER (38)
BILL_TO_SITE_USE_ID NUMBER (15)
BILL_TO_CONTACT_ID NUMBER (15)
SERVICE_TXN_AVAILABILITY_CODE VARCHAR2 (30)
NEXT_PM_VISIT_DATE DATE

PM_VISITS_COMPLETED NUMBER (38)
LAST_PM_VISIT_DATE DATE

PM_SCHEDULE_ID NUMBER (15)
PM_SCHEDULE_FLAG VARCHAR2 (1)
CURRENT_MAX_SCHEDULE_DATE DATE

PRICE_LIST_ID NUMBER (15)
PRICING_ATTRIBUTE1 VARCHAR2 (150)
PRICING_ATTRIBUTE2 VARCHAR2 (150)
PRICING_ATTRIBUTE3 VARCHAR2 (150)
PRICING_ATTRIBUTE4 VARCHAR2 (150)
PRICING_ATTRIBUTE5 VARCHAR2 (150)
PRICING_ATTRIBUTE6 VARCHAR2 (150)
PRICING_ATTRIBUTE7 VARCHAR2 (150)
PRICING_ATTRIBUTE8 VARCHAR2 (150)
PRICING_ATTRIBUTE9 VARCHAR2 (150)
PRICING_ATTRIBUTE10 VARCHAR2 (150)
PRICING_ATTRIBUTE11 VARCHAR2 (150)
PRICING_ATTRIBUTE12 VARCHAR2 (150)
PRICING_ATTRIBUTE13 VARCHAR2 (150)
PRICING_ATTRIBUTE14 VARCHAR2 (150)
PRICING_ATTRIBUTE15 VARCHAR2 (150)
PRICING_CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CONTEXT VARCHAR2 (30)
SERVICE_ORDER_TYPE VARCHAR2 (30)
INVOICE_COUNT NUMBER

CURRENCY_CODE VARCHAR2 (30)
CONVERSION_TYPE VARCHAR2 (30)
CONVERSION_RATE NUMBER

CONVERSION_DATE DATE

ORIGINAL_SERVICE_LINE_ID NUMBER (15)
WARRANTY_FLAG VARCHAR2 (1)
ORG_ID NUMBER

ORIGINAL_START_DATE DATE

ORIGINAL_END_DATE DATE

SERVICE_DATE_CHANGE VARCHAR2 (1)
CONTRACT_ID NUMBER (15)
WORKFLOW VARCHAR2 (30)
CONTRACT_LINE_STATUS_ID NUMBER (15)
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (30)
EXTENDED_PRICE NUMBER

DISCOUNT_ID NUMBER (15)
TAX_CODE VARCHAR2 (15)
BILLING_FREQUENCY_PERIOD VARCHAR2 (240)
FIRST_BILL_DATE DATE

NEXT_BILL_DATE DATE

BILL_ON NUMBER (15)
LIST_PRICE NUMBER

PRICE_PERCENT NUMBER

CONTRACT_LINE_TEMPLATE_ID NUMBER (15)
SHIP_TO_SITE_USE_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

CS.CS_CP_SERVICES_ALL does not reference any database object

CS.CS_CP_SERVICES_ALL is referenced by following:

SchemaAPPS
SynonymCS_CP_SERVICES_ALL