APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 438: FROM ahl_schedule_materials

434: CURSOR Schedule_Matrl_cur (C_SCH_MAT_ID IN NUMBER) IS
435: --Added by sowsubra - status needs be fetched
436: SELECT scheduled_material_id,uom,status,
437: organization_id,visit_task_id
438: FROM ahl_schedule_materials
439: WHERE scheduled_material_id = C_SCH_MAT_ID;
440:
441: CURSOR Item_Des_cur(c_item_id IN NUMBER, c_org_id IN NUMBER) IS
442: SELECT CONCATENATED_SEGMENTS

Line 943: from ahl_schedule_materials asmt,

939: /*
940: -- Changed for fixing perf bug:4919540
941: select DECODE( SIGN( trunc(scheduled_date) - trunc(requested_date)),1,scheduled_date,null) scheduled_date,
942: scheduled_quantity
943: from ahl_schedule_materials asmt,
944: AHL_VISIT_TASKS_B tsk
945: where TSK.VISIT_ID = ASMT.VISIT_ID
946: AND TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
947: AND NVL(ASMT.STATUS,' ') <> 'DELETED'

Line 954: FROM ahl_schedule_materials asmt,

950: */
951: SELECT scheduled_date ,
952: status, --Added by sowsubra
953: scheduled_quantity
954: FROM ahl_schedule_materials asmt,
955: AHL_VISIT_TASKS_B tsk
956: WHERE TSK.VISIT_ID = ASMT.VISIT_ID
957: AND TSK.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
958: AND NVL(ASMT.STATUS,' ') <> 'DELETED'

Line 1222: UPDATE ahl_schedule_materials

1218: l_temp_atp_table(i).item_description := x_atp_table.inventory_item_name(i);
1219:
1220: --yazhou 12-May-2006 starts
1221: --Bug fix #5223772
1222: UPDATE ahl_schedule_materials
1223: SET scheduled_date = x_atp_table.ship_date(i),
1224: scheduled_quantity = l_planned_matrl_tbl(i).required_quantity,
1225: object_version_number = object_version_number + 1
1226: WHERE scheduled_material_id = x_atp_table.identifier(i);

Line 1345: FROM ahl_schedule_materials schm,

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

Line 1622: FROM ahl_schedule_materials schm,

1618: schm.inventory_item_id,
1619: schm.requested_date,
1620: schm.requested_quantity,
1621: mtl.concatenated_segments
1622: FROM ahl_schedule_materials schm,
1623: mtl_system_items_vl mtl
1624: WHERE schm.inventory_item_id = mtl.inventory_item_id
1625: AND schm.organization_id = mtl.organization_id
1626: AND schm.requested_quantity <> 0