View: XNS_CUSTOMER_PRODUCTS_MAINT_V

View Text

SELECT CP.ROW_ID
, CP.CUSTOMER_PRODUCT_ID
, CP.LAST_UPDATE_DATE
, CP.LAST_UPDATED_BY
, CP.CREATION_DATE
, CP.CREATED_BY
, CP.LAST_UPDATE_LOGIN
, CP.ACCOUNT_NUMBER
, NULL PRINCIPAL_PARTY_NAME
, CP.CUSTOMER_ID
, CP.INVENTORY_ITEM_ID
, CP.CREATED_MANUALLY_FLAG
, CP.MOST_RECENT_FLAG
, CP.CURRENT_CP_REVISION_ID
, CP.CURRENT_SERIAL_NUMBER
, CP.TYPE_CODE
, CP.SYSTEM_ID
, CP.INSTALLATION_DATE
, CP.ORIGINAL_ORDER_LINE_ID
, CP.ORDERED_DATE ORIGINAL_ORDER_DATE
, CP.ORDER_NUMBER ORIGINAL_ORDER_NUMBER
, CP.LINE_NUMBER ORIGINAL_ORDER_LINE_NUMBER
, CP.LINK_TO_LINE_ID ORIGINAL_LINK_TO_ORDER_LINE_ID
, CP.ORIGINAL_LINE_SERV_DETAIL_ID
, NULL ORIGINAL_NET_AMOUNT
, CP.PRICE_LIST_ID
, CP.SHIP_TO_SITE_USE_ID
, CP.BILL_TO_SITE_USE_ID
, CP.INSTALL_SITE_USE_ID
, CP.QUANTITY
, CP.SHIPPED_FLAG
, CP.DELIVERED_FLAG
, CP.UNIT_OF_MEASURE_CODE
, CP.PARENT_CP_ID
, CP.START_DATE_ACTIVE
, CP.END_DATE_ACTIVE
, CP.ATTRIBUTE1
, CP.ATTRIBUTE2
, CP.ATTRIBUTE3
, CP.ATTRIBUTE4
, CP.ATTRIBUTE5
, CP.ATTRIBUTE6
, CP.ATTRIBUTE7
, CP.ATTRIBUTE8
, CP.ATTRIBUTE9
, CP.ATTRIBUTE10
, CP.ATTRIBUTE11
, CP.ATTRIBUTE12
, CP.ATTRIBUTE13
, CP.ATTRIBUTE14
, CP.ATTRIBUTE15
, CP.CONTEXT
, CP.CUSTOMER_PRODUCT_STATUS_ID
, CP.SHIPPED_DATE
, CP.ORG_ID
, CP.REFERENCE_NUMBER
, CP.CUST_PO_NUMBER PURCHASE_ORDER_NUM
, CP.CP_LOT_NUMBER
, CP.SPLIT_FLAG
, CP.CP_STATUS
, CP.CANCELLED_FLAG
, CP.TERMINATED_FLAG
, CP.STATUS_CHANGE_ALLOWED_FLAG
, CP.INCIDENT_ALLOWED_FLAG
, CP.SERVICE_ORDER_ALLOWED_FLAG
, CP.SYSTEM
, CP.CP_TYPE
, CP.PRODUCT_AGREEMENT
, CP.REVISION
, CP.SERIAL_NUMBER_CONTROL_CODE
, CP.PRODUCT_DESCRIPTION
, NULL SERVICED_STATUS
, NULL SERVICED_STATUS_FLAG
, CP.BOM_ITEM_TYPE
, CP.RETURN_BY_DATE
, CP.ACTUAL_RETURNED_DATE
, CP.CONFIG_ENABLED_FLAG
, CP.CONFIG_START_DATE
, CP.CONFIG_END_DATE
, CP.CONFIG_ROOT_ID
, CP.CONFIG_PARENT_ID
, CP.CONFIG_TYPE
, NULL CP_CONFIG_TYPE
, CP.RMA_LINE_ID
, CP.PROJECT_ID
, CP.TASK_ID
, CP.PLATFORM_VERSION_ID
, NULL PLATFORM_VERSION
, CP.CONCATENATED_SEGMENTS
, NULL SHIP_TO_PARTY_ID
, NULL SHIP_TO_PARTY_NAME
, NULL SHIP_TO_PARTY_TYPE
, NULL SHIP_TO_PARTY_LAST_NAME
, NULL SHIP_TO_PARTY_FIRST_NAME
, NULL SHIP_TO_LOCATION_ID
, NULL SHIP_TO_LOCATION_DESC
, NULL SHIP_TO_ADDRESS1
, NULL SHIP_TO_ADDRESS2
, NULL SHIP_TO_ADDRESS3
, NULL SHIP_TO_ADDRESS4
, NULL SHIP_TO_MAILSTOP
, NULL SHIP_TO_CITY
, NULL SHIP_TO_POSTAL_CODE
, NULL SHIP_TO_STATE
, NULL SHIP_TO_PROVINCE
, NULL SHIP_TO_COUNTY
, NULL SHIP_TO_COUNTRY
, NULL INSTALL_TO_PARTY_ID
, NULL INSTALL_TO_PARTY_NAME
, NULL INSTALL_TO_PARTY_TYPE
, NULL INSTALL_TO_PARTY_LAST_NAME
, NULL INSTALL_TO_PARTY_FIRST_NAME
, NULL INSTALL_TO_LOCATION_ID
, NULL INSTALL_TO_LOCATION_DESC
, NULL INSTALL_TO_ADDRESS1
, NULL INSTALL_TO_ADDRESS2
, NULL INSTALL_TO_ADDRESS3
, NULL INSTALL_TO_ADDRESS4
, NULL INSTALL_TO_MAILSTOP
, NULL INSTALL_TO_CITY
, NULL INSTALL_TO_POSTAL_CODE
, NULL INSTALL_TO_STATE
, NULL INSTALL_TO_PROVINCE
, NULL INSTALL_TO_COUNTY
, NULL INSTALL_TO_COUNTRY
, NULL BILL_TO_PARTY_ID
, NULL BILL_TO_PARTY_NAME
, NULL BILL_TO_PARTY_TYPE
, NULL BILL_TO_PARTY_LAST_NAME
, NULL BILL_TO_PARTY_FIRST_NAME
, NULL BILL_TO_LOCATION_ID
, NULL BILL_TO_LOCATION_DESC
, NULL BILL_TO_ADDRESS1
, NULL BILL_TO_ADDRESS2
, NULL BILL_TO_ADDRESS3
, NULL BILL_TO_ADDRESS4
, NULL BILL_TO_MAILSTOP
, NULL BILL_TO_CITY
, NULL BILL_TO_POSTAL_CODE
, NULL BILL_TO_STATE
, NULL BILL_TO_PROVINCE
, NULL BILL_TO_COUNTY
, NULL BILL_TO_COUNTRY
, NULL ORGANIZATION_NAME
, CP.MERCHANT_VIEW_FLAG
, CP.CUSTOMER_VIEW_FLAG
FROM CS_CUST_PROD_MAINT_V CP

Columns