View: CS_NEW_INCIDENTS_V_SEC

Product:	CS - Service
Description:	This is a secured view created on top of the view CS_NEW_INCIDENTS_V
Implementation/DBA Data:	APPS.CS_NEW_INCIDENTS_V_SEC

View Text

SELECT INC.INCIDENT_ID
, INC.PROBLEM_CODE
, INC.RESOLUTION_CODE
, INC.CUSTOMER_PRODUCT_ID
, INC.INV_ORGANIZATION_ID
, INC.CP_COMPONENT_ID
, INC.CP_SUBCOMPONENT_ID
, INC.INVENTORY_ITEM_ID
, INC.INV_COMPONENT_ID
, INC.INV_COMPONENT_VERSION
, INC.INV_SUBCOMPONENT_ID
, INC.INV_SUBCOMPONENT_VERSION
, INC.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER_NV
, INC.PLATFORM_ID
, INC.PLATFORM_VERSION_ID
, STATUS.NAME STATUS_CODE
, TYPE.NAME INCIDENT_TYPE
, SEV.NAME SEVERITY
, URGENCY.NAME URGENCY
, OWN.RESOURCE_NAME OWNER
, PARTY.PARTY_NAME COMPANY_NAME
, ACCOUNT.ACCOUNT_NUMBER ACCOUNT
, INC.CUSTOMER_ID
, INC.CUSTOMER_TICKET_NUMBER
, SR_PARTY.SUB_FIRST_NAME PERSON_FIRST_NAME
, SR_PARTY.SUB_LAST_NAME PERSON_LAST_NAME
, INC.INCIDENT_DATE
, INC.CLOSE_DATE DATE_CLOSED
, KFV.CONCATENATED_SEGMENTS PRODUCT_NAME
, KFV.DESCRIPTION PRODUCT_DESCRIPTION
, TL.SUMMARY
FROM CS_INCIDENTS_B_SEC INC
, CS_INCIDENT_STATUSES_VL STATUS
, CS_INCIDENT_TYPES_VL_SEC TYPE
, CS_INCIDENT_SEVERITIES_VL SEV
, CS_INCIDENT_URGENCIES_VL URGENCY
, CS_SR_OWNERS_V OWN
, JTF_PARTIES_ALL_V PARTY
, JTF_CUST_ACCOUNTS_ALL_V ACCOUNT
, CS_HZ_SR_CONTACT_POINTS SR_CONT
, CSC_HZ_PARTIES_SELF_V SR_PARTY
, MTL_SYSTEM_ITEMS_KFV KFV
, CS_INCIDENTS_ALL_TL TL
WHERE INC.INCIDENT_ID = TL.INCIDENT_ID
AND TL.LANGUAGE = USERENV('LANG')
AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND INC.INCIDENT_URGENCY_ID = URGENCY.INCIDENT_URGENCY_ID (+)
AND INC.INCIDENT_SEVERITY_ID = SEV.INCIDENT_SEVERITY_ID
AND INC.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID (+)
AND KFV.ORGANIZATION_ID (+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND INC.INCIDENT_OWNER_ID = OWN.RESOURCE_ID(+)
AND INC.RESOURCE_TYPE = OWN.RESOURCE_TYPE(+)
AND INC.CUSTOMER_ID = PARTY.PARTY_ID (+)
AND INC.ACCOUNT_ID = ACCOUNT.CUST_ACCOUNT_ID (+)
AND SR_CONT.INCIDENT_ID (+) = INC.INCIDENT_ID
AND SR_CONT.PARTY_ID = SR_PARTY.PARTY_ID (+)
AND SR_CONT.PRIMARY_FLAG (+) = 'Y'

Columns