APPS.BOM_DIAGUNITTEST_ECOHLCHK dependencies on MTL_PARAMETERS

Line 48: from mtl_parameters

44:
45: If l_org_id is not null Then /* validate if input org_id exists*/
46: Begin
47: select 1 into l_org_exists
48: from mtl_parameters
49: where organization_id=l_org_id;
50: Exception
51: When others Then
52: l_org_exists :=0;

Line 76: ' from eng_engineering_changes eec, mtl_parameters mp '||

72: ' ecsvl.status_name "Current Status Name", '||
73: ' eec.status_type "Current Status Type", '||
74: ' eec.change_id "Change Id", '||
75: ' eec.organization_id "Organization Id" '||
76: ' from eng_engineering_changes eec, mtl_parameters mp '||
77: ' ,eng_change_statuses_vl ecsvl '||
78: ' where eec.organization_id = mp.organization_id '||
79: ' and eec.APPROVAL_STATUS_TYPE <> 4 '||
80: ' and eec.status_type not in (5,6) '||