APPS.RCV_ROI_RETURN dependencies on MTL_PARAMETERS

Line 226: mtl_parameters mp

222: IF (x_cascaded_table(n).ship_to_location_code IS NOT NULL) THEN
223: SELECT max(mp.organization_code)
224: INTO x_to_organization_code
225: FROM hr_locations hl,
226: mtl_parameters mp
227: WHERE x_cascaded_table(n).ship_to_location_code = hl.location_code
228: AND hl.inventory_organization_id = mp.organization_id;
229:
230: x_cascaded_table(n).to_organization_code := x_to_organization_code;

Line 1361: mtl_parameters mp

1357:
1358: SELECT NVL(mp.negative_inv_receipt_code, -999)
1359: INTO l_negative_inv_receipt_code
1360: FROM mtl_system_items msi,
1361: mtl_parameters mp
1362: WHERE mp.organization_id = p_to_organization_id
1363: AND msi.organization_id = mp.organization_id
1364: AND msi.inventory_item_id = p_item_id;
1365:

Line 1369: FROM mtl_parameters

1365:
1366: IF (l_negative_inv_receipt_code = -999) THEN
1367: SELECT negative_inv_receipt_code
1368: INTO l_negative_inv_receipt_code
1369: FROM mtl_parameters
1370: WHERE organization_id = p_to_organization_id;
1371: END IF;
1372:
1373: l_tree_mode := inv_quantity_tree_pub.g_transaction_mode;