APPS.WSMPLBJI dependencies on MTL_PARAMETERS

Line 345: --bug 5051783:Replaced org_organization_definitions with mtl_parameters.

341: CLOSE c_org;
342:
343: if l_org_id IS NULL then
344: begin
345: --bug 5051783:Replaced org_organization_definitions with mtl_parameters.
346: select organization_id
347: into l_org_id
348: --from ORG_ORGANIZATION_DEFINITIONS
349: from mtl_parameters

Line 349: from mtl_parameters

345: --bug 5051783:Replaced org_organization_definitions with mtl_parameters.
346: select organization_id
347: into l_org_id
348: --from ORG_ORGANIZATION_DEFINITIONS
349: from mtl_parameters
350: where organization_code = l_org_code;
351: exception
352: when others then
353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 363: from MTL_PARAMETERS MP ,

359:
360: begin
361: select 1
362: into l_temp
363: from MTL_PARAMETERS MP ,
364: WSM_PARAMETERS WSM,
365: HR_ALL_ORGANIZATION_UNITS ORG,
366: WIP_PARAMETERS WP
367: where MP.ORGANIZATION_ID = WSM.ORGANIZATION_ID

Line 4201: mtl_parameters MP

4197: into l_sub_loc_control, l_org_loc_control,
4198: l_restrict_locators_code, l_item_loc_control
4199: FROM mtl_system_items MS,
4200: mtl_secondary_inventories MSUB,
4201: mtl_parameters MP
4202: WHERE MP.organization_id = v_wlji_org(v_index)
4203: AND MS.organization_id = v_wlji_org(v_index)
4204: AND MS.inventory_item_id = v_wlji_item(v_index)
4205: AND MSUB.secondary_inventory_name = v_wlji_completion_subinventory(v_index)

Line 5753: mtl_parameters MP

5749: into l_sub_loc_control, l_org_loc_control,
5750: l_restrict_locators_code, l_item_loc_control
5751: FROM mtl_system_items MS,
5752: mtl_secondary_inventories MSUB,
5753: mtl_parameters MP
5754: WHERE MP.organization_id = v_wlji_org(v_index)
5755: AND MS.organization_id = v_wlji_org(v_index)
5756: AND MS.inventory_item_id = v_wlji_item(v_index)
5757: AND MSUB.secondary_inventory_name = v_wlji_completion_subinventory(v_index)

Line 7488: --bug 5051783:Replaced org_organization_definitions with mtl_parameters.

7484: -- note that this is a rudimentary piece of commentary on the job created,
7485: -- or failed to create because there's no customer requirement on this.
7486: if v_wlji_load_type(v_index) = 5 then
7487: fnd_file.put_line(fnd_file.output, '-------------------------------------------------------');
7488: --bug 5051783:Replaced org_organization_definitions with mtl_parameters.
7489: select organization_code
7490: into org_code
7491: --from ORG_ORGANIZATION_DEFINITIONS
7492: from mtl_parameters

Line 7492: from mtl_parameters

7488: --bug 5051783:Replaced org_organization_definitions with mtl_parameters.
7489: select organization_code
7490: into org_code
7491: --from ORG_ORGANIZATION_DEFINITIONS
7492: from mtl_parameters
7493: where organization_id = v_wlji_org(v_index);
7494:
7495: fnd_file.put_line(fnd_file.output, 'Organization: '||org_code);
7496: fnd_file.put_line(fnd_file.output, 'Job_name: '|| v_wlji_job_name(v_index));