DBA Data[Home] [Help]

APPS.CS_WORKFLOW_PKG dependencies on CS_INCIDENT_TYPES

Line 34: CS_INCIDENT_TYPES_VL it,

30: ) install_address
31: FROM
32: CS_INCIDENTS_V sr,
33: -- CS_INCIDENT_ACTIONS_V act,
34: CS_INCIDENT_TYPES_VL it,
35: HZ_PARTY_SITES hps,
36: HZ_LOCATIONS hl
37: WHERE it.incident_type_id = sr.incident_type_id
38: AND sr.incident_id = fs_request_id

Line 102: from cs_incidents_all_b inc, cs_incident_types types, wf_activities wf

98: l_item_type VARCHAR2(10);
99:
100: CURSOR l_itemtype_csr IS --Bug 6449697
101: Select item_type
102: from cs_incidents_all_b inc, cs_incident_types types, wf_activities wf
103: where inc.incident_number= p_request_number
104: and types.incident_type_id=inc.incident_type_id
105: and wf.name=types.workflow;
106:

Line 589: cs_incident_types cit

585: inc.incident_id,
586: inc.object_version_number
587: FROM cs_incident_statuses status,
588: cs_incidents_all_b inc,
589: cs_incident_types cit
590: WHERE inc.incident_number = p_request_number
591: AND inc.incident_status_id = status.incident_status_id
592: and cit.incident_type_id = inc.incident_type_id;
593: