DBA Data[Home] [Help]

APPS.WMS_RULE_EXTN_PVT dependencies on MTL_RESERVATIONS

Line 334: FROM mtl_reservations mr

330:
331: CURSOR c_high_level_res_csr IS
332: SELECT mr.organization_id org_id,
333: mr.reservation_id res_id
334: FROM mtl_reservations mr
335: WHERE mr.organization_id = p_mo_line_rec.organization_id
336: AND mr.demand_source_type_id = INV_GLOBALS.G_SOURCETYPE_WIP
337: AND mr.demand_source_header_id = p_demand_source_header_id
338: AND mr.demand_source_line_id = p_demand_source_line_id

Line 397: FROM mtl_reservations mr

393: serial_number, grade_code, from_cost_group_id, to_cost_group_id;
394:
395: CURSOR c_rsv_primary_qty(p_rsv_id NUMBER) IS
396: SELECT mr.primary_reservation_quantity
397: FROM mtl_reservations mr
398: WHERE mr.reservation_id = p_rsv_id;
399:
400: BEGIN
401: