View: CS_SERVICE_REQUEST_PUB_V

Product:	CS - Service
Description:	Service Request
Implementation/DBA Data:	APPS.CS_SERVICE_REQUEST_PUB_V

View Text

SELECT INC.ROWID
, INC.INCIDENT_NUMBER
, INC.INCIDENT_ID
, INC_TL.SUMMARY SERVICE_REQUEST_SUMMARY
, INC.OBJECT_VERSION_NUMBER
, INC.EXPECTED_RESOLUTION_DATE
, INC.INCIDENT_DATE
, INC.INCIDENT_LAST_MODIFIED_DATE
, INC.LAST_UPDATE_DATE
, INC.LAST_UPDATED_BY
, INC.CREATION_DATE
, INC.CREATED_BY
, GRP_OWN.GROUP_NAME
, IND_OWN.RESOURCE_NAME
, INC.INCIDENT_OCCURRED_DATE
, INC.INCIDENT_RESOLVED_DATE
, INC.INC_RESPONDED_BY_DATE
, INC.CLOSE_DATE DATE_CLOSED
, INC.OBLIGATION_DATE
, INC.SR_CREATION_CHANNEL
, INCIDENT_LOCATION_TYPE
, INCIDENT_LOCATION_ID
, TYPE.NAME
, SEV.NAME
, STATUS.NAME
, INC.STATUS_FLAG
, URGENCY.NAME
, MSI.CONCATENATED_SEGMENTS
, INC.INV_ITEM_REVISION
, PARTY.PARTY_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, PARTY.PARTY_NUMBER CUSTOMER_NUMBER
, PARTY.PARTY_TYPE
, ACC.ACCOUNT_NUMBER
, PROB_LOOK.MEANING
, RES_LOOK.MEANING
, CSI.INSTANCE_NUMBER CUSTOMER_PRODUCT_ID
, INC.PRODUCT_REVISION
FROM CS_INCIDENTS_B_SEC INC
, CS_INCIDENTS_ALL_TL INC_TL
, CS_INCIDENT_TYPES_TL TYPE
, CS_INCIDENT_SEVERITIES_TL SEV
, CS_INCIDENT_STATUSES_TL STATUS
, CS_INCIDENT_URGENCIES_TL URGENCY
, MTL_SYSTEM_ITEMS_KFV MSI
, HZ_CUST_ACCOUNTS ACC
, HZ_PARTIES PARTY
, JTF_RS_RESOURCE_EXTNS_TL IND_OWN
, JTF_RS_GROUPS_TL GRP_OWN
, FND_LOOKUP_VALUES PROB_LOOK
, FND_LOOKUP_VALUES RES_LOOK
, CSI_ITEM_INSTANCES CSI
WHERE PARTY.PARTY_ID = INC.CUSTOMER_ID
AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND TYPE.LANGUAGE = USERENV('LANG')
AND INC.INCIDENT_SEVERITY_ID = SEV.INCIDENT_SEVERITY_ID
AND SEV.LANGUAGE = USERENV('LANG')
AND STATUS.INCIDENT_STATUS_ID = INC.INCIDENT_STATUS_ID
AND STATUS.LANGUAGE = USERENV('LANG')
AND INC.INCIDENT_URGENCY_ID = URGENCY.INCIDENT_URGENCY_ID(+)
AND URGENCY.LANGUAGE(+) = USERENV('LANG')
AND MSI.ORGANIZATION_ID(+) = INC.INV_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
AND ACC.CUST_ACCOUNT_ID(+) = INC.ACCOUNT_ID
AND IND_OWN.RESOURCE_ID(+) = INC.INCIDENT_OWNER_ID
AND IND_OWN.LANGUAGE(+) = USERENV('LANG')
AND GRP_OWN.GROUP_ID(+) = INC.OWNER_GROUP_ID
AND GRP_OWN.LANGUAGE(+) = USERENV('LANG')
AND PROB_LOOK.LOOKUP_CODE(+) = INC.PROBLEM_CODE
AND PROB_LOOK.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
AND RES_LOOK.LOOKUP_CODE(+) = INC.RESOLUTION_CODE
AND RES_LOOK.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'
AND PROB_LOOK.LANGUAGE(+) = USERENV('LANG')
AND PROB_LOOK.VIEW_APPLICATION_ID(+) = 170
AND PROB_LOOK.SECURITY_GROUP_ID(+) = GREATEST (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10))))
AND RES_LOOK.LANGUAGE(+) = USERENV('LANG')
AND RES_LOOK.VIEW_APPLICATION_ID(+) = 170
AND RES_LOOK.SECURITY_GROUP_ID(+) = GREATEST (0
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10))))
AND INC.INCIDENT_ID = INC_TL.INCIDENT_ID
AND INC_TL.LANGUAGE = USERENV('LANG')
AND CSI.INSTANCE_ID (+) = INC.CUSTOMER_PRODUCT_ID

Columns