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 FND_LOOKUP_VALUES_VL

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 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 1461: FND_LOOKUP_VALUES_VL FLV

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
1464: AND ASMT.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID(+)
1465: AND ASMT.ORGANIZATION_ID = KFV.ORGANIZATION_ID(+)