View: CS_SR_NEW_ACC_CP_RG_V

Product:	CS - Service
Description:	This view is used by the main service request form for a record group to retrieve release 11.5.6 and higher, install base informationr .
Implementation/DBA Data:	APPS.CS_SR_NEW_ACC_CP_RG_V

View Text

SELECT ITEM.INSTANCE_ID
, SI.CONCATENATED_SEGMENTS PRODUCT_NAME
, SI.DESCRIPTION PRODUCT_DESCRIPTION
, ITEM.INVENTORY_ITEM_ID
, ITEM.SERIAL_NUMBER
, ITEM.SYSTEM_ID
, SYS.NAME SYSTEM_NAME
, ITEM.INVENTORY_REVISION
, SI.ITEM_TYPE PRODUCT_TYPE
, ITEM.INSTANCE_STATUS_ID
, INST.NAME CUSTOMER_PRODUCT_STATUS
, ITEM.INSTANCE_NUMBER
, ITEM.LOT_NUMBER
, ASOHDR.CUST_PO_NUMBER
, ASOHDR.ORDER_NUMBER
, IR.OBJECT_ID
, TO_NUMBER(NULL) PLATFORM_ID
, NULL PLATFORM
, TO_NUMBER(NULL) PLATFORM_VERSION_ID
, NULL VERSION
, INST.INCIDENT_ALLOWED_FLAG
, ITEM.OWNER_PARTY_ACCOUNT_ID PARTY_ACCOUNT_ID
, ITEM.LOCATION_ID
, ITEM.INV_MASTER_ORGANIZATION_ID
, ITEM.EXTERNAL_REFERENCE
, ITEM.OWNER_PARTY_ID
, ITEM.OWNER_PARTY_SOURCE_TABLE
, ITEM.LOCATION_TYPE_CODE
, SI.ORGANIZATION_ID
, ITEM.INSTANCE_DESCRIPTION INSTANCE_NAME
, TO_NUMBER(NULL) MAINT_ORGANIZATION_ID FROM CSI_ITEM_INSTANCES ITEM
, CSI_INSTANCE_STATUSES INST
, CSI_SYSTEMS_TL SYS
, MTL_SYSTEM_ITEMS_VL SI
, OE_ORDER_LINES_ALL ASOLIN
, OE_ORDER_HEADERS_ALL ASOHDR
, CSI_II_RELATIONSHIPS IR
WHERE ITEM.SYSTEM_ID = SYS.SYSTEM_ID(+)
AND SYS.LANGUAGE(+) = USERENV('LANG')
AND ITEM.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES'
AND INST.INSTANCE_STATUS_ID = ITEM.INSTANCE_STATUS_ID
AND INST.INCIDENT_ALLOWED_FLAG = 'Y'
AND ITEM.INVENTORY_ITEM_ID =SI.INVENTORY_ITEM_ID
AND ITEM.LAST_OE_ORDER_LINE_ID= ASOLIN.LINE_ID (+)
AND ASOLIN.HEADER_ID= ASOHDR.HEADER_ID (+)
AND IR.SUBJECT_ID (+) = ITEM.INSTANCE_ID
AND IR.RELATIONSHIP_TYPE_CODE (+) = 'COMPONENT-OF'
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(ITEM.ACTIVE_START_DATE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(ITEM.ACTIVE_END_DATE)
, TRUNC(SYSDATE))
AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(IR.ACTIVE_START_DATE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(IR.ACTIVE_END_DATE)
, TRUNC(SYSDATE))
AND SI.SERV_REQ_ENABLED_CODE = 'E'
AND SI.COMMS_NL_TRACKABLE_FLAG='Y'

Columns