APPS.PJM_PROJECT_LOCATOR dependencies on MTL_PARAMETERS

Line 629: FROM mtl_parameters

625: WHERE organization_id = C_organization_id;
626:
627: CURSOR C_Cost_Method ( C_organization_id NUMBER) IS
628: SELECT primary_cost_method
629: FROM mtl_parameters
630: WHERE organization_id = C_organization_id;
631:
632: CURSOR C_Proj_Param ( C_organization_id NUMBER
633: , C_project_id NUMBER) IS

Line 810: from mtl_parameters

806: CURSOR C_Org_Controls(org_id NUMBER) IS
807: SELECT project_reference_enabled,
808: project_control_level,
809: organization_code
810: from mtl_parameters
811: where organization_id = org_id;
812:
813: CURSOR C_Loc_Attrib(loc_id NUMBER, org_id NUMBER) IS
814: SELECT project_id,

Line 1145: mtl_parameters mp

1141: l_item_loc_restrict,
1142: l_item_sub_restrict,
1143: l_org_loc_control
1144: FROM mtl_system_items mtl,
1145: mtl_parameters mp
1146: WHERE mtl.inventory_item_id = p_item_id
1147: AND mtl.organization_id = p_organization_id
1148: AND mtl.organization_id = mp.organization_id;
1149:

Line 1417: FROM mtl_parameters mp

1413: SELECT NVL(mp.project_reference_enabled, 2),
1414: mp.stock_locator_control_code
1415: INTO L_proj_ref_enabled,
1416: l_org_loc_control
1417: FROM mtl_parameters mp
1418: WHERE mp.organization_id = p_organization_id;
1419:
1420: exception
1421: when others then

Line 1550: FROM mtl_parameters mp

1546: SELECT NVL(mp.project_reference_enabled, 2),
1547: mp.stock_locator_control_code
1548: INTO L_proj_ref_enabled,
1549: l_org_loc_control
1550: FROM mtl_parameters mp
1551: WHERE mp.organization_id = p_organization_id;
1552:
1553: EXCEPTION
1554: WHEN OTHERS THEN