APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_PARAMETERS

Line 74: from mtl_onhand_quantities_detail moqd, mtl_parameters mp

70: select 1
71: into count_assigned
72: from dual
73: where exists (select 1
74: from mtl_onhand_quantities_detail moqd, mtl_parameters mp
75: where moqd.organization_id = mp.organization_id
76: and mp.default_status_id is not null
77: and nvl(moqd.status_id, -9999) = p_status_id
78: and rownum = 1); -- Do we need to add rownum as the query is inside 'exists'.

Line 882: FROM mtl_parameters

878: inv_trx_util_pub.TRACE('validate_mtstatus: New status does not allow reservation: '||p_new_status_id, 'INV_MATERIAL_STATUS_PKG', 14);
879:
880: /* Validating the organization material status for bug 1243008 */
881: SELECT default_status_id INTO l_default_status_id
882: FROM mtl_parameters
883: WHERE organization_id = p_organization_id;
884:
885: IF l_default_status_id IS NOT NULL THEN
886: inv_trx_util_pub.TRACE('validate_mtstatus: Organization is onhand status enabled:', 'INV_MATERIAL_STATUS_PKG', 14);