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_TASK_MATRL_V

Line 705: item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed

701: visit_id,
702: visit_task_id,
703: visit_task_name,
704: inventory_item_id,
705: item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
706: requested_quantity,
707: requested_date,
708: scheduled_date,
709: scheduled_quantity,

Line 714: FROM ahl_visit_task_matrl_v, FND_LOOKUP_VALUES_VL

710: uom,
711: sales_order_line_id,
712: task_status_code,
713: meaning
714: FROM ahl_visit_task_matrl_v, FND_LOOKUP_VALUES_VL
715: WHERE visit_id = C_VISIT_ID
716: AND (requested_quantity <> 0)
717: AND NVL(mat_status,'X') <> 'IN-SERVICE' --Added by sowsubra
718: AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'

Line 1344: avtm.item_number --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed

1340: schm.organization_id,
1341: schm.uom,
1342: schm.requested_date,
1343: schm.status mat_status, --Added by sowsubra
1344: avtm.item_number --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1345: FROM ahl_schedule_materials schm,
1346: ahl_visit_task_matrl_v avtm
1347: WHERE schm.scheduled_material_id = avtm.schedule_material_id
1348: AND avtm.schedule_material_id = c_sch_mat_id;

Line 1346: ahl_visit_task_matrl_v avtm

1342: schm.requested_date,
1343: schm.status mat_status, --Added by sowsubra
1344: avtm.item_number --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1345: FROM ahl_schedule_materials schm,
1346: ahl_visit_task_matrl_v avtm
1347: WHERE schm.scheduled_material_id = avtm.schedule_material_id
1348: AND avtm.schedule_material_id = c_sch_mat_id;
1349:
1350: -- anraj modified by adding two more columns task status code and meaning

Line 1358: item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed

1354: visit_task_name,
1355: requested_quantity,
1356: scheduled_date,
1357: scheduled_quantity,
1358: item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1359: object_version_number,
1360: inventory_item_id,
1361: uom,
1362: requested_date,

Line 1365: FROM ahl_visit_task_matrl_v,FND_LOOKUP_VALUES_VL

1361: uom,
1362: requested_date,
1363: task_status_code,
1364: meaning
1365: FROM ahl_visit_task_matrl_v,FND_LOOKUP_VALUES_VL
1366: WHERE schedule_material_id = c_sch_mat_id
1367: AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'
1368: AND LOOKUP_code = task_status_code;
1369:

Line 1498: --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed

1494: p_x_planned_matrl_tbl(i).schedule_material_id := l_temp_planned_matrl_tbl(i).schedule_material_id;
1495: p_x_planned_matrl_tbl(i).object_version_number := l_Planned_Material_Rec.object_version_number;
1496: p_x_planned_matrl_tbl(i).inventory_item_id := l_Planned_Material_Rec.inventory_item_id;
1497:
1498: --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1499: p_x_planned_matrl_tbl(i).item_description := l_Planned_Material_Rec.item_number;
1500:
1501: p_x_planned_matrl_tbl(i).visit_id := l_Planned_Material_Rec.visit_id;
1502: p_x_planned_matrl_tbl(i).visit_task_id := l_Planned_Material_Rec.visit_task_id;