eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on AHL_VISIT_TASKS_V

Line 995: FROM ahl_visit_tasks_v

991: --yazhou 12-May-2006 ends
992:
993: CURSOR Order_Number_Cur(c_visit_task_id IN NUMBER) IS
994: SELECT visit_number||visit_task_number Order_Number
995: FROM ahl_visit_tasks_v
996: WHERE visit_task_id = c_visit_task_id;
997:
998: CURSOR Instance_Id_Cur IS
999: SELECT instance_id

Line 1459: AHL_VISIT_TASKS_VL AVTL,

1455: ASMT.REQUESTED_DATE,
1456: AVTL.STATUS_CODE TASK_STATUS_CODE,
1457: FLV.MEANING
1458: FROM AHL_SCHEDULE_MATERIALS ASMT,
1459: AHL_VISIT_TASKS_VL AVTL,
1460: MTL_SYSTEM_ITEMS_KFV KFV,
1461: FND_LOOKUP_VALUES_VL FLV
1462: WHERE SCHEDULED_MATERIAL_ID = c_sch_mat_id
1463: AND AVTL.VISIT_TASK_ID = ASMT.VISIT_TASK_ID

Line 1935: FROM ahl_visit_tasks_v

1931: AND lookup_code = C_Error_Code;
1932:
1933: CURSOR Order_Number_Cur(c_visit_task_id IN NUMBER) IS
1934: SELECT visit_number||visit_task_number Order_Number
1935: FROM ahl_visit_tasks_v
1936: WHERE visit_task_id = c_visit_task_id;
1937:
1938: CURSOR Instance_Id_Cur IS
1939: SELECT instance_id