View: CS_ACC_CP_RG_V

Product:	CS - Service
Description:	This view is used by the main service request form for a record group to retrieve install base information.
Implementation/DBA Data:	APPS.CS_ACC_CP_RG_V

View Text

SELECT CP.CUSTOMER_PRODUCT_ID
, KFV.CONCATENATED_SEGMENTS PRODUCT_NAME
, KFV.DESCRIPTION PRODUCT_DESCRIPTION
, CP.INVENTORY_ITEM_ID
, CP.CURRENT_SERIAL_NUMBER
, CP.SYSTEM_ID
, SYS.NAME SYSTEM_NAME
, CP.CURRENT_CP_REVISION_ID
, REV.REVISION
, KFV.ITEM_TYPE PRODUCT_TYPE
, CP.CUSTOMER_PRODUCT_STATUS_ID
, CPS.NAME CUSTOMER_PRODUCT_STATUS
, CP.REFERENCE_NUMBER
, CP.LOT_NUMBER
, ASOHDR.CUST_PO_NUMBER
, ASOHDR.ORDER_NUMBER
, CP.CONFIG_ROOT_ID
, CP.CONFIG_PARENT_ID
, TO_NUMBER(NULL) PLATFORM_ID
, NULL PLATFORM
, TO_NUMBER(NULL) PLATFORM_VERSION_ID
, NULL VERSION
, CP.ORG_ID
, CPS.INCIDENT_ALLOWED_FLAG
, CP.CUSTOMER_ID
, CP.INSTALL_SITE_USE_ID
FROM CS_CUSTOMER_PRODUCTS_ALL CP
, CS_CUSTOMER_PRODUCT_STATUSES CPS
, CS_CP_REVISIONS REV
, CS_SYSTEMS SYS
, CS_LOOKUPS CSL
, MTL_SYSTEM_ITEMS_KFV KFV
, OE_ORDER_LINES_ALL ASOLIN
, OE_ORDER_HEADERS_ALL ASOHDR
WHERE CP.SYSTEM_ID = SYS.SYSTEM_ID(+) AND CP.TYPE_CODE = CSL.LOOKUP_CODE(+) AND CSL.LOOKUP_TYPE(+) = 'CUSTOMER_PRODUCT_TYPE' AND CP.CUSTOMER_PRODUCT_ID = REV.CUSTOMER_PRODUCT_ID AND CP.CURRENT_CP_REVISION_ID = REV.CP_REVISION_ID AND CP.CUSTOMER_PRODUCT_STATUS_ID = CPS.CUSTOMER_PRODUCT_STATUS_ID
AND CP.CUSTOMER_PRODUCT_STATUS_ID NOT IN (4
, 1003) AND CP.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND KFV.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID AND CP.ORIGINAL_ORDER_LINE_ID= ASOLIN.LINE_ID (+) AND ASOLIN.HEADER_ID= ASOHDR.HEADER_ID (+) AND SYSDATE BETWEEN NVL(CP.START_DATE_ACTIVE
, SYSDATE)
AND NVL(CP.END_DATE_ACTIVE
, SYSDATE)

Columns