APPS.WMS_UT_PKG dependencies on MTL_PARAMETERS

Line 1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

1087: mr.secondary_reservation_quantity || ', ' ||
1088: mr.secondary_uom_code || ', ' ||
1089: Nvl(mr.secondary_detailed_quantity,0) as p_text
1090: INTO l_rt
1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
1092: WHERE reservation_id = l_new_reservation_id
1093: AND msi.organization_id = mr.organization_id
1094: AND msi.inventory_item_id = mr.inventory_item_id
1095: AND mp.organization_id = mr.organization_id

Line 2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

2219: mr.secondary_reservation_quantity || ', ' ||
2220: mr.secondary_uom_code || ', ' ||
2221: Nvl(mr.secondary_detailed_quantity,0) as p_text,
2222: mr.reservation_id as reservation_id
2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
2224: WHERE
2225: Nvl(mr.supply_source_type_id, 13) = 13
2226: AND g_demand_tbl(p_di).demand_source_type_id = mr.demand_source_type_id
2227: AND nvl(g_demand_tbl(p_di).demand_source_header_id,-9999) = nvl(mr.demand_source_header_id, -9999)

Line 2863: ||' from mtl_parameters'

2859: ||' '
2860: ||' l_org_code := wms_ut_pkg.get_value(l_data, ''ORG'');'
2861: ||' select organization_id'
2862: ||' into l_org_id'
2863: ||' from mtl_parameters'
2864: ||' where organization_code = l_org_code;'
2865: ||' '
2866: ||' g_testname := l_test_rec.testname;'
2867: ||' wms_ut_pkg.gather_and_setup(l_data, l_org_id, p_user_id, l_test_rec.flow_type_id, p_run_id, l_test_id);'