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 4195: mtl_parameters MP

4191: into l_sub_loc_control, l_org_loc_control,
4192: l_restrict_locators_code, l_item_loc_control
4193: FROM mtl_system_items MS,
4194: mtl_secondary_inventories MSUB,
4195: mtl_parameters MP
4196: WHERE MP.organization_id = v_wlji_org(v_index)
4197: AND MS.organization_id = v_wlji_org(v_index)
4198: AND MS.inventory_item_id = v_wlji_item(v_index)
4199: AND MSUB.secondary_inventory_name = v_wlji_completion_subinventory(v_index)

Line 5747: mtl_parameters MP

5743: into l_sub_loc_control, l_org_loc_control,
5744: l_restrict_locators_code, l_item_loc_control
5745: FROM mtl_system_items MS,
5746: mtl_secondary_inventories MSUB,
5747: mtl_parameters MP
5748: WHERE MP.organization_id = v_wlji_org(v_index)
5749: AND MS.organization_id = v_wlji_org(v_index)
5750: AND MS.inventory_item_id = v_wlji_item(v_index)
5751: AND MSUB.secondary_inventory_name = v_wlji_completion_subinventory(v_index)

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

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

Line 7486: from mtl_parameters

7482: --bug 5051783:Replaced org_organization_definitions with mtl_parameters.
7483: select organization_code
7484: into org_code
7485: --from ORG_ORGANIZATION_DEFINITIONS
7486: from mtl_parameters
7487: where organization_id = v_wlji_org(v_index);
7488:
7489: fnd_file.put_line(fnd_file.output, 'Organization: '||org_code);
7490: fnd_file.put_line(fnd_file.output, 'Job_name: '|| v_wlji_job_name(v_index));