DBA Data[Home] [Help]

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 1304: mtl_parameters mp

1300:
1301: SELECT NVL(mp.negative_inv_receipt_code, -999)
1302: INTO l_negative_inv_receipt_code
1303: FROM mtl_system_items msi,
1304: mtl_parameters mp
1305: WHERE mp.organization_id = p_to_organization_id
1306: AND msi.organization_id = mp.organization_id
1307: AND msi.inventory_item_id = p_item_id;
1308:

Line 1312: FROM mtl_parameters

1308:
1309: IF (l_negative_inv_receipt_code = -999) THEN
1310: SELECT negative_inv_receipt_code
1311: INTO l_negative_inv_receipt_code
1312: FROM mtl_parameters
1313: WHERE organization_id = p_to_organization_id;
1314: END IF;
1315:
1316: l_tree_mode := inv_quantity_tree_pub.g_transaction_mode;