Skip to content

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

TABLE: CS.CS_CUSTOMER_PRODUCTS_ALL_OLD

Object Details
Object Name: CS_CUSTOMER_PRODUCTS_ALL_OLD
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_CUSTOMER_PRODUCTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREFERENCE_NUMBER
ColumnORG_ID
CS_CUSTOMER_PRODUCTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCUSTOMER_ID
CS_CUSTOMER_PRODUCTS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnORIGINAL_ORDER_NUMBER
CS_CUSTOMER_PRODUCTS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSERVICE_AGREEMENT_ID
CS_CUSTOMER_PRODUCTS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCOMPONENT_FROZEN_FLAG
CS_CUSTOMER_PRODUCTS_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCONFIG_PARENT_ID
CS_CUSTOMER_PRODUCTS_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnORIGINAL_LINE_SERV_DETAIL_ID
CS_CUSTOMER_PRODUCTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnINVENTORY_ITEM_ID
CS_CUSTOMER_PRODUCTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSYSTEM_ID
CS_CUSTOMER_PRODUCTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPARENT_CP_ID
CS_CUSTOMER_PRODUCTS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnORIGINAL_ORDER_LINE_ID
CS_CUSTOMER_PRODUCTS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCURRENT_SERIAL_NUMBER
CS_CUSTOMER_PRODUCTS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnRIGHT_TO_COPY_PARENT_CP_ID
CS_CUSTOMER_PRODUCTS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPRODUCT_AGREEMENT_ID
CS_CUSTOMER_PRODUCTS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCURRENT_CP_REVISION_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_PRODUCT_ID NUMBER
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_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
LOT_NUMBER VARCHAR2 (30)
CREATED_MANUALLY_FLAG VARCHAR2 (1) Yes
CONFIRMED_FLAG VARCHAR2 (1)
MOST_RECENT_FLAG VARCHAR2 (1) Yes
CURRENT_CP_REVISION_ID NUMBER (15) Yes
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
STATUS_CODE VARCHAR2 (30)
TYPE_CODE VARCHAR2 (30)
SYSTEM_ID NUMBER

PRODUCT_AGREEMENT_ID NUMBER

SERVICE_AGREEMENT_ID NUMBER (15)
INSTALLATION_DATE DATE

ORIGINAL_ORDER_LINE_ID NUMBER

ORIGINAL_ORDER_DATE DATE

ORIGINAL_ORDER_NUMBER NUMBER (15)
ORIGINAL_ORDER_LINE_NUMBER NUMBER (15)
ORIGINAL_LINE_SERV_DETAIL_ID NUMBER

ORIGINAL_NET_AMOUNT NUMBER (28)
PRICE_LIST_ID NUMBER (15)
SHIP_TO_SITE_USE_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER

INSTALL_SITE_USE_ID NUMBER

SERVICE_ADMIN_CONTACT_ID NUMBER (15)
SUPPORT_CONTACT_ID NUMBER (15)
SHIP_TO_CONTACT_ID NUMBER (15)
BILL_TO_CONTACT_ID NUMBER (15)
QUANTITY NUMBER

SHIPPED_FLAG VARCHAR2 (1)
DELIVERED_FLAG VARCHAR2 (1)
UNIT_OF_MEASURE_CODE VARCHAR2 (25) Yes
UPDATED_MANUALLY_FLAG VARCHAR2 (1)
PARENT_CP_ID NUMBER

RIGHT_TO_COPY_PARENT_CP_ID NUMBER (15)
ORDER_PRODUCT_AGREEMENT_ID NUMBER (15)
ORDER_SERVICE_AGREEMENT_ID NUMBER (15)
ORDER_SHIP_TO_SITE_USE_ID NUMBER (15)
ORDER_BILL_TO_SITE_USE_ID NUMBER (15)
ORDER_SHIP_TO_CONTACT_ID NUMBER (15)
ORDER_BILL_TO_CONTACT_ID NUMBER (15)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

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)
CONTEXT VARCHAR2 (30)
CONFIRM_REASON_CODE VARCHAR2 (30)
CONFIRM_COMMENTS VARCHAR2 (240)
CUSTOMER_PRODUCT_STATUS_ID NUMBER
Yes
TXN_AVAILABILITY_CODE VARCHAR2 (30)
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)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
PICKING_HEADER_ID NUMBER (15)
SHIPPED_DATE DATE

ORG_ID NUMBER

REFERENCE_NUMBER NUMBER

PARENT_REFERENCE_NUMBER NUMBER

RETURN_BY_DATE DATE

ACTUAL_RETURNED_DATE DATE

RMA_HEADER_ID NUMBER (15)
RMA_NUMBER NUMBER

RMA_LINE_ID NUMBER (15)
RMA_LINE_NUMBER NUMBER

ATO_FLAG VARCHAR2 (1)
ORIGINAL_ORDER_ATO_LINE_ID NUMBER (15)
ORIGINAL_ORDER_PARENT_LINE_ID NUMBER (38)
PURCHASE_ORDER_NUM VARCHAR2 (50)
ORIGINAL_ORDER_CURRENCY_CODE VARCHAR2 (15)
SPLIT_FLAG VARCHAR2 (1)
COMPONENT_FROZEN_FLAG VARCHAR2 (1)
INCLUDED_ITEM_FLAG VARCHAR2 (1)
ORIG_ORDER_LINE_DETAIL_ID NUMBER

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
CONFIG_ENABLED_FLAG VARCHAR2 (1)
CONFIG_START_DATE DATE

CONFIG_END_DATE DATE

CONFIG_ROOT_ID NUMBER

CONFIG_PARENT_ID NUMBER

CONFIG_TYPE VARCHAR2 (30)
PLATFORM_VERSION_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Yes
MERCHANT_VIEW_FLAG VARCHAR2 (1)
CUSTOMER_VIEW_FLAG VARCHAR2 (1)
SECURITY_GROUP_ID NUMBER

PRICING_ATTRIBUTE16 VARCHAR2 (150)
PRICING_ATTRIBUTE17 VARCHAR2 (150)
PRICING_ATTRIBUTE18 VARCHAR2 (150)
PRICING_ATTRIBUTE19 VARCHAR2 (150)
PRICING_ATTRIBUTE20 VARCHAR2 (150)
PRICING_ATTRIBUTE21 VARCHAR2 (150)
PRICING_ATTRIBUTE22 VARCHAR2 (150)
PRICING_ATTRIBUTE23 VARCHAR2 (150)
PRICING_ATTRIBUTE24 VARCHAR2 (150)
PRICING_ATTRIBUTE25 VARCHAR2 (150)
PRICING_ATTRIBUTE26 VARCHAR2 (150)
PRICING_ATTRIBUTE27 VARCHAR2 (150)
PRICING_ATTRIBUTE28 VARCHAR2 (150)
PRICING_ATTRIBUTE29 VARCHAR2 (150)
PRICING_ATTRIBUTE30 VARCHAR2 (150)
PRICING_ATTRIBUTE31 VARCHAR2 (150)
PRICING_ATTRIBUTE32 VARCHAR2 (150)
PRICING_ATTRIBUTE33 VARCHAR2 (150)
PRICING_ATTRIBUTE34 VARCHAR2 (150)
PRICING_ATTRIBUTE35 VARCHAR2 (150)
PRICING_ATTRIBUTE36 VARCHAR2 (150)
PRICING_ATTRIBUTE37 VARCHAR2 (150)
PRICING_ATTRIBUTE38 VARCHAR2 (150)
PRICING_ATTRIBUTE39 VARCHAR2 (150)
PRICING_ATTRIBUTE40 VARCHAR2 (150)
PRICING_ATTRIBUTE41 VARCHAR2 (150)
PRICING_ATTRIBUTE42 VARCHAR2 (150)
PRICING_ATTRIBUTE43 VARCHAR2 (150)
PRICING_ATTRIBUTE44 VARCHAR2 (150)
PRICING_ATTRIBUTE45 VARCHAR2 (150)
PRICING_ATTRIBUTE46 VARCHAR2 (150)
PRICING_ATTRIBUTE47 VARCHAR2 (150)
PRICING_ATTRIBUTE48 VARCHAR2 (150)
PRICING_ATTRIBUTE49 VARCHAR2 (150)
PRICING_ATTRIBUTE50 VARCHAR2 (150)
PRICING_ATTRIBUTE51 VARCHAR2 (150)
PRICING_ATTRIBUTE52 VARCHAR2 (150)
PRICING_ATTRIBUTE53 VARCHAR2 (150)
PRICING_ATTRIBUTE54 VARCHAR2 (150)
PRICING_ATTRIBUTE55 VARCHAR2 (150)
PRICING_ATTRIBUTE56 VARCHAR2 (150)
PRICING_ATTRIBUTE57 VARCHAR2 (150)
PRICING_ATTRIBUTE58 VARCHAR2 (150)
PRICING_ATTRIBUTE59 VARCHAR2 (150)
PRICING_ATTRIBUTE61 VARCHAR2 (150)
PRICING_ATTRIBUTE62 VARCHAR2 (150)
PRICING_ATTRIBUTE63 VARCHAR2 (150)
PRICING_ATTRIBUTE64 VARCHAR2 (150)
PRICING_ATTRIBUTE65 VARCHAR2 (150)
PRICING_ATTRIBUTE66 VARCHAR2 (150)
PRICING_ATTRIBUTE67 VARCHAR2 (150)
PRICING_ATTRIBUTE68 VARCHAR2 (150)
PRICING_ATTRIBUTE69 VARCHAR2 (150)
PRICING_ATTRIBUTE70 VARCHAR2 (150)
PRICING_ATTRIBUTE71 VARCHAR2 (150)
PRICING_ATTRIBUTE72 VARCHAR2 (150)
PRICING_ATTRIBUTE73 VARCHAR2 (150)
PRICING_ATTRIBUTE74 VARCHAR2 (150)
PRICING_ATTRIBUTE75 VARCHAR2 (150)
PRICING_ATTRIBUTE76 VARCHAR2 (150)
PRICING_ATTRIBUTE77 VARCHAR2 (150)
PRICING_ATTRIBUTE78 VARCHAR2 (150)
PRICING_ATTRIBUTE79 VARCHAR2 (150)
PRICING_ATTRIBUTE80 VARCHAR2 (150)
PRICING_ATTRIBUTE81 VARCHAR2 (150)
PRICING_ATTRIBUTE82 VARCHAR2 (150)
PRICING_ATTRIBUTE83 VARCHAR2 (150)
PRICING_ATTRIBUTE84 VARCHAR2 (150)
PRICING_ATTRIBUTE85 VARCHAR2 (150)
PRICING_ATTRIBUTE86 VARCHAR2 (150)
PRICING_ATTRIBUTE87 VARCHAR2 (150)
PRICING_ATTRIBUTE88 VARCHAR2 (150)
PRICING_ATTRIBUTE89 VARCHAR2 (150)
PRICING_ATTRIBUTE90 VARCHAR2 (150)
PRICING_ATTRIBUTE91 VARCHAR2 (150)
PRICING_ATTRIBUTE92 VARCHAR2 (150)
PRICING_ATTRIBUTE93 VARCHAR2 (150)
PRICING_ATTRIBUTE94 VARCHAR2 (150)
PRICING_ATTRIBUTE95 VARCHAR2 (150)
PRICING_ATTRIBUTE96 VARCHAR2 (150)
PRICING_ATTRIBUTE97 VARCHAR2 (150)
PRICING_ATTRIBUTE98 VARCHAR2 (150)
PRICING_ATTRIBUTE99 VARCHAR2 (150)
PRICING_ATTRIBUTE100 VARCHAR2 (150)
PRICING_ATTRIBUTE60 VARCHAR2 (150)
UPGRADED_STATUS_FLAG VARCHAR2 (1)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

EXPIRED_FLAG VARCHAR2 (1)
RETURNED_QUANTITY NUMBER

VALID_FOR_CSI_MIGRATION VARCHAR2 (1)
Query Text

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


SELECT CUSTOMER_PRODUCT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      LOT_NUMBER
,      CREATED_MANUALLY_FLAG
,      CONFIRMED_FLAG
,      MOST_RECENT_FLAG
,      CURRENT_CP_REVISION_ID
,      CURRENT_SERIAL_NUMBER
,      STATUS_CODE
,      TYPE_CODE
,      SYSTEM_ID
,      PRODUCT_AGREEMENT_ID
,      SERVICE_AGREEMENT_ID
,      INSTALLATION_DATE
,      ORIGINAL_ORDER_LINE_ID
,      ORIGINAL_ORDER_DATE
,      ORIGINAL_ORDER_NUMBER
,      ORIGINAL_ORDER_LINE_NUMBER
,      ORIGINAL_LINK_TO_ORDER_LINE_ID
,      ORIGINAL_LINE_SERV_DETAIL_ID
,      ORIGINAL_NET_AMOUNT
,      PRICE_LIST_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      INSTALL_SITE_USE_ID
,      SERVICE_ADMIN_CONTACT_ID
,      SUPPORT_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      BILL_TO_CONTACT_ID
,      QUANTITY
,      SHIPPED_FLAG
,      DELIVERED_FLAG
,      UNIT_OF_MEASURE_CODE
,      UPDATED_MANUALLY_FLAG
,      PARENT_CP_ID
,      RIGHT_TO_COPY_PARENT_CP_ID
,      ORDER_PRODUCT_AGREEMENT_ID
,      ORDER_SERVICE_AGREEMENT_ID
,      ORDER_SHIP_TO_SITE_USE_ID
,      ORDER_BILL_TO_SITE_USE_ID
,      ORDER_SHIP_TO_CONTACT_ID
,      ORDER_BILL_TO_CONTACT_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      CONFIRM_REASON_CODE
,      CONFIRM_COMMENTS
,      CUSTOMER_PRODUCT_STATUS_ID
,      TXN_AVAILABILITY_CODE
,      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
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PICKING_HEADER_ID
,      SHIPPED_DATE
,      ORG_ID
,      REFERENCE_NUMBER
,      PARENT_REFERENCE_NUMBER
,      RETURN_BY_DATE
,      ACTUAL_RETURNED_DATE
,      RMA_HEADER_ID
,      RMA_NUMBER
,      RMA_LINE_ID
,      RMA_LINE_NUMBER
,      ATO_FLAG
,      ORIGINAL_ORDER_ATO_LINE_ID
,      ORIGINAL_ORDER_PARENT_LINE_ID
,      PURCHASE_ORDER_NUM
,      ORIGINAL_ORDER_CURRENCY_CODE
,      SPLIT_FLAG
,      COMPONENT_FROZEN_FLAG
,      INCLUDED_ITEM_FLAG
,      ORIG_ORDER_LINE_DETAIL_ID
,      PROJECT_ID
,      TASK_ID
,      CONFIG_ENABLED_FLAG
,      CONFIG_START_DATE
,      CONFIG_END_DATE
,      CONFIG_ROOT_ID
,      CONFIG_PARENT_ID
,      CONFIG_TYPE
,      PLATFORM_VERSION_ID
,      OBJECT_VERSION_NUMBER
,      MERCHANT_VIEW_FLAG
,      CUSTOMER_VIEW_FLAG
,      SECURITY_GROUP_ID
,      PRICING_ATTRIBUTE16
,      PRICING_ATTRIBUTE17
,      PRICING_ATTRIBUTE18
,      PRICING_ATTRIBUTE19
,      PRICING_ATTRIBUTE20
,      PRICING_ATTRIBUTE21
,      PRICING_ATTRIBUTE22
,      PRICING_ATTRIBUTE23
,      PRICING_ATTRIBUTE24
,      PRICING_ATTRIBUTE25
,      PRICING_ATTRIBUTE26
,      PRICING_ATTRIBUTE27
,      PRICING_ATTRIBUTE28
,      PRICING_ATTRIBUTE29
,      PRICING_ATTRIBUTE30
,      PRICING_ATTRIBUTE31
,      PRICING_ATTRIBUTE32
,      PRICING_ATTRIBUTE33
,      PRICING_ATTRIBUTE34
,      PRICING_ATTRIBUTE35
,      PRICING_ATTRIBUTE36
,      PRICING_ATTRIBUTE37
,      PRICING_ATTRIBUTE38
,      PRICING_ATTRIBUTE39
,      PRICING_ATTRIBUTE40
,      PRICING_ATTRIBUTE41
,      PRICING_ATTRIBUTE42
,      PRICING_ATTRIBUTE43
,      PRICING_ATTRIBUTE44
,      PRICING_ATTRIBUTE45
,      PRICING_ATTRIBUTE46
,      PRICING_ATTRIBUTE47
,      PRICING_ATTRIBUTE48
,      PRICING_ATTRIBUTE49
,      PRICING_ATTRIBUTE50
,      PRICING_ATTRIBUTE51
,      PRICING_ATTRIBUTE52
,      PRICING_ATTRIBUTE53
,      PRICING_ATTRIBUTE54
,      PRICING_ATTRIBUTE55
,      PRICING_ATTRIBUTE56
,      PRICING_ATTRIBUTE57
,      PRICING_ATTRIBUTE58
,      PRICING_ATTRIBUTE59
,      PRICING_ATTRIBUTE61
,      PRICING_ATTRIBUTE62
,      PRICING_ATTRIBUTE63
,      PRICING_ATTRIBUTE64
,      PRICING_ATTRIBUTE65
,      PRICING_ATTRIBUTE66
,      PRICING_ATTRIBUTE67
,      PRICING_ATTRIBUTE68
,      PRICING_ATTRIBUTE69
,      PRICING_ATTRIBUTE70
,      PRICING_ATTRIBUTE71
,      PRICING_ATTRIBUTE72
,      PRICING_ATTRIBUTE73
,      PRICING_ATTRIBUTE74
,      PRICING_ATTRIBUTE75
,      PRICING_ATTRIBUTE76
,      PRICING_ATTRIBUTE77
,      PRICING_ATTRIBUTE78
,      PRICING_ATTRIBUTE79
,      PRICING_ATTRIBUTE80
,      PRICING_ATTRIBUTE81
,      PRICING_ATTRIBUTE82
,      PRICING_ATTRIBUTE83
,      PRICING_ATTRIBUTE84
,      PRICING_ATTRIBUTE85
,      PRICING_ATTRIBUTE86
,      PRICING_ATTRIBUTE87
,      PRICING_ATTRIBUTE88
,      PRICING_ATTRIBUTE89
,      PRICING_ATTRIBUTE90
,      PRICING_ATTRIBUTE91
,      PRICING_ATTRIBUTE92
,      PRICING_ATTRIBUTE93
,      PRICING_ATTRIBUTE94
,      PRICING_ATTRIBUTE95
,      PRICING_ATTRIBUTE96
,      PRICING_ATTRIBUTE97
,      PRICING_ATTRIBUTE98
,      PRICING_ATTRIBUTE99
,      PRICING_ATTRIBUTE100
,      PRICING_ATTRIBUTE60
,      UPGRADED_STATUS_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EXPIRED_FLAG
,      RETURNED_QUANTITY
,      VALID_FOR_CSI_MIGRATION
FROM CS.CS_CUSTOMER_PRODUCTS_ALL_OLD;

Dependencies

[top of page]

CS.CS_CUSTOMER_PRODUCTS_ALL_OLD does not reference any database object

CS.CS_CUSTOMER_PRODUCTS_ALL_OLD is referenced by following:

SchemaCS
ViewCS_CUSTOMER_PRODUCTS_ALL_OLD#