APPS.PJM_PROJECT_LOCATOR dependencies on MTL_PARAMETERS

Line 647: FROM mtl_parameters

643: WHERE organization_id = C_organization_id;
644:
645: CURSOR C_Cost_Method ( C_organization_id NUMBER) IS
646: SELECT primary_cost_method
647: FROM mtl_parameters
648: WHERE organization_id = C_organization_id;
649:
650: CURSOR C_Proj_Param ( C_organization_id NUMBER
651: , C_project_id NUMBER) IS

Line 864: from mtl_parameters

860: CURSOR C_Org_Controls(org_id NUMBER) IS
861: SELECT project_reference_enabled,
862: project_control_level,
863: organization_code
864: from mtl_parameters
865: where organization_id = org_id;
866:
867: CURSOR C_Loc_Attrib(loc_id NUMBER, org_id NUMBER) IS
868: SELECT project_id,

Line 1200: mtl_parameters mp

1196: l_item_loc_restrict,
1197: l_item_sub_restrict,
1198: l_org_loc_control
1199: FROM mtl_system_items mtl,
1200: mtl_parameters mp
1201: WHERE mtl.inventory_item_id = p_item_id
1202: AND mtl.organization_id = p_organization_id
1203: AND mtl.organization_id = mp.organization_id;
1204:

Line 1476: FROM mtl_parameters mp

1472: SELECT NVL(mp.project_reference_enabled, 2),
1473: mp.stock_locator_control_code
1474: INTO L_proj_ref_enabled,
1475: l_org_loc_control
1476: FROM mtl_parameters mp
1477: WHERE mp.organization_id = p_organization_id;
1478:
1479: exception
1480: when others then

Line 1609: FROM mtl_parameters mp

1605: SELECT NVL(mp.project_reference_enabled, 2),
1606: mp.stock_locator_control_code
1607: INTO L_proj_ref_enabled,
1608: l_org_loc_control
1609: FROM mtl_parameters mp
1610: WHERE mp.organization_id = p_organization_id;
1611:
1612: EXCEPTION
1613: WHEN OTHERS THEN