APPS.INV_AUTODETAIL dependencies on MTL_PARAMETERS

Line 52: -- mtl_parameters.

48: --
49: -- --------------------------------------------------------------------------
50: -- What does it do:
51: -- Fetches picking rule. First from mtl_system_items. If absent there, tries
52: -- mtl_parameters.
53: -- --------------------------------------------------------------------------
54: PROCEDURE get_pick_rule
55: ( p_organization_id IN NUMBER
56: ,p_inventory_item_id IN NUMBER

Line 283: FROM mtl_parameters mp

279:
280: /* CURSOR l_cost_method IS
281: SELECT primary_cost_method
282: ,default_cost_group_id
283: FROM mtl_parameters mp
284: WHERE mp.organization_id = p_organization_id;
285:
286: CURSOR l_cost_group_csr IS
287: SELECT default_cost_group_id

Line 845: from mtl_parameters

841: * is a non-pjm org then pass NULL as project_id and task_id
842: */
843: select project_reference_enabled
844: into l_pjm_org
845: from mtl_parameters
846: where organization_id = p_request_line_rec.organization_id;
847:
848: if(l_pjm_org = 2) then
849:

Line 1217: l_org_rec MTL_PARAMETERS%ROWTYPE;

1213: l_serial_number VARCHAR2(30);
1214:
1215: l_from_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1216: l_to_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1217: l_org_rec MTL_PARAMETERS%ROWTYPE;
1218: l_item_rec MTL_SYSTEM_ITEMS%ROWTYPE;
1219: l_ret_value NUMBER;
1220: l_move_order_type NUMBER;
1221: --Bug Number 3449739

Line 1239: FROM MTL_PARAMETERS

1235: AND organization_id = p_request_line_rec.organization_id;
1236:
1237: CURSOR l_org_cursor IS
1238: SELECT *
1239: FROM MTL_PARAMETERS
1240: WHERE organization_id = p_request_line_rec.organization_id;
1241:
1242: CURSOR l_item_cursor IS
1243: SELECT *