APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_SCHEDULE_MATERIALS_S

Line 346: l_mat_status AHL_SCHEDULE_MATERIALS.STATUS%TYPE; --Added by sowsubra for Issue 105

342: l_task_type_code VARCHAR2(30);
343: l_material_request_type VARCHAR2(30);
344: l_Prior_Item_Rec Get_Prior_Item_Cur%ROWTYPE;
345: l_isInservice AHL_RT_OPER_MATERIALS.IN_SERVICE%TYPE; --Added by sowsubra for Issue 105
346: l_mat_status AHL_SCHEDULE_MATERIALS.STATUS%TYPE; --Added by sowsubra for Issue 105
347:
348: BEGIN
349:
350: IF (l_log_procedure >= l_log_current_level)THEN

Line 378: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id

374:
375: END IF;
376:
377: --Get the sequence number
378: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id
379: FROM DUAL;
380: --Check for record exists
381: OPEN check_matrl_cur(p_visit_id,p_visit_task_id,p_rt_oper_material_id);
382: FETCH check_matrl_cur INTO l_dummy;

Line 909: ahl_schedule_materials SM

905: THEN
906: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
907: INTO l_rsvd_quantity
908: FROM mtl_reservations MR,
909: ahl_schedule_materials SM
910: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
911: AND MR.external_source_code = 'AHL'
912: AND MR.demand_source_line_detail = SM.scheduled_material_id
913: AND MR.organization_id = SM.organization_id

Line 951: ahl_schedule_materials SM

947: THEN
948: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
949: INTO l_rsvd_quantity
950: FROM mtl_reservations MR,
951: ahl_schedule_materials SM
952: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
953: AND MR.external_source_code = 'AHL'
954: AND MR.demand_source_line_detail = SM.scheduled_material_id
955: AND MR.organization_id = SM.organization_id