DBA Data[Home] [Help]

APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on FND_LOOKUP_VALUES_VL

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 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: