VIEW: APPS.CS_SERVICE_REQUEST_PUB_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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