DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on CS_INCIDENTS_ALL_TL

Line 2548: FROM CS_INCIDENTS_ALL_TL CS_TL

2544: AND CS_EMPL.PERSON_ID = SR_CONT.PARTY_ID
2545: )) SR_CONTACT_NAME,
2546: CS.PROBLEM_CODE ,
2547: (SELECT CS_TL.SUMMARY
2548: FROM CS_INCIDENTS_ALL_TL CS_TL
2549: WHERE LANGUAGE = USERENV('LANG')
2550: AND CS.INCIDENT_ID = CS_TL.INCIDENT_ID
2551: ) SR_PROBLEM_SUMMARY ,
2552: (SELECT CS_SEV.NAME

Line 7910: CS_INCIDENTS_ALL_TL CS_TL

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
7914: AND CS.INCIDENT_ID = CS_TL.INCIDENT_ID