DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on CS_INCIDENT_TYPES_TL

Line 2597: CS_INCIDENT_TYPES_TL CS_TYPE,

2593: CS_INCIDENTS_ALL_B CS,
2594: AHL_WORKORDERS WO,
2595: AHL_VISIT_TASKS_B VISIT_TASK,
2596: HZ_PARTIES PARTY ,
2597: CS_INCIDENT_TYPES_TL CS_TYPE,
2598: (SELECT INCIDENT_ID ,
2599: PARTY_ID ,
2600: CONTACT_TYPE
2601: FROM CS_HZ_SR_CONTACT_POINTS

Line 7909: CS_INCIDENT_TYPES_TL CS_TYPE,

7905: CS_TL.SUMMARY,
7906: TSK.VISIT_TASK_ID
7907: FROM CS_INCIDENTS_ALL_B CS,
7908: AHL_VISIT_TASKS_B TSK,
7909: CS_INCIDENT_TYPES_TL CS_TYPE,
7910: CS_INCIDENTS_ALL_TL CS_TL
7911: WHERE CS.INCIDENT_ID = TSK.SERVICE_REQUEST_ID
7912: --AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID
7913: AND CS.INCIDENT_TYPE_ID = CS_TYPE.INCIDENT_TYPE_ID