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 729: item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed

725: visit_id,
726: visit_task_id,
727: visit_task_name,
728: inventory_item_id,
729: item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
730: requested_quantity,
731: requested_date,
732: scheduled_date,
733: scheduled_quantity,

Line 738: FROM ahl_visit_task_matrl_v, FND_LOOKUP_VALUES_VL

734: uom,
735: sales_order_line_id,
736: task_status_code,
737: meaning
738: FROM ahl_visit_task_matrl_v, FND_LOOKUP_VALUES_VL
739: WHERE visit_id = C_VISIT_ID
740: --SKPATHAK :: Bug 8429732 :: 17-APR-2009
741: --Commented out the condition (requested_quantity <> 0)
742: /* AND (requested_quantity <> 0) */

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

1394: schm.organization_id,
1395: schm.uom,
1396: schm.requested_date,
1397: schm.status mat_status, --Added by sowsubra
1398: avtm.item_number --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1399: FROM ahl_schedule_materials schm,
1400: ahl_visit_task_matrl_v avtm
1401: WHERE schm.scheduled_material_id = avtm.schedule_material_id
1402: AND avtm.schedule_material_id = c_sch_mat_id;

Line 1400: ahl_visit_task_matrl_v avtm

1396: schm.requested_date,
1397: schm.status mat_status, --Added by sowsubra
1398: avtm.item_number --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1399: FROM ahl_schedule_materials schm,
1400: ahl_visit_task_matrl_v avtm
1401: WHERE schm.scheduled_material_id = avtm.schedule_material_id
1402: AND avtm.schedule_material_id = c_sch_mat_id;
1403: */
1404: -- arunjk modified the above cursor to retrieve the item number from base table since ahl_visit_task_matrl_v has only Planned Material Requirements

Line 1404: -- arunjk modified the above cursor to retrieve the item number from base table since ahl_visit_task_matrl_v has only Planned Material Requirements

1400: ahl_visit_task_matrl_v avtm
1401: WHERE schm.scheduled_material_id = avtm.schedule_material_id
1402: AND avtm.schedule_material_id = c_sch_mat_id;
1403: */
1404: -- arunjk modified the above cursor to retrieve the item number from base table since ahl_visit_task_matrl_v has only Planned Material Requirements
1405: CURSOR Sch_Material_Cur (c_sch_mat_id IN NUMBER) IS
1406: SELECT schm.inventory_item_id,
1407: AVTM.organization_id,
1408: schm.uom,

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

1422: visit_task_name,
1423: requested_quantity,
1424: scheduled_date,
1425: scheduled_quantity,
1426: item_number, --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1427: object_version_number,
1428: inventory_item_id,
1429: uom,
1430: requested_date,

Line 1433: FROM ahl_visit_task_matrl_v,FND_LOOKUP_VALUES_VL

1429: uom,
1430: requested_date,
1431: task_status_code,
1432: meaning
1433: FROM ahl_visit_task_matrl_v,FND_LOOKUP_VALUES_VL
1434: WHERE schedule_material_id = c_sch_mat_id
1435: AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'
1436: AND LOOKUP_code = task_status_code;
1437: */

Line 1439: -- arunjk modified the above cursor to retrieve the details from base tables since ahl_visit_task_matrl_v has only Planned Material Requirements

1435: AND LOOKUP_TYPE(+) = 'AHL_VWP_TASK_STATUS'
1436: AND LOOKUP_code = task_status_code;
1437: */
1438:
1439: -- arunjk modified the above cursor to retrieve the details from base tables since ahl_visit_task_matrl_v has only Planned Material Requirements
1440: CURSOR Planned_Material_Cur (c_sch_mat_id IN NUMBER) IS
1441: SELECT ASMT.VISIT_ID,
1442: ASMT.VISIT_TASK_ID,
1443: AVTL.VISIT_TASK_NAME,

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

1593: p_x_planned_matrl_tbl(i).schedule_material_id := l_temp_planned_matrl_tbl(i).schedule_material_id;
1594: p_x_planned_matrl_tbl(i).object_version_number := l_Planned_Material_Rec.object_version_number;
1595: p_x_planned_matrl_tbl(i).inventory_item_id := l_Planned_Material_Rec.inventory_item_id;
1596:
1597: --Modified by rnahata for ER 6391157, ahl_visit_task_matrl_v definition changed
1598: p_x_planned_matrl_tbl(i).item_description := l_Planned_Material_Rec.item_number;
1599:
1600: p_x_planned_matrl_tbl(i).visit_id := l_Planned_Material_Rec.visit_id;
1601: p_x_planned_matrl_tbl(i).visit_task_id := l_Planned_Material_Rec.visit_task_id;