APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_PARAMETERS

Line 985: -- changed from org_organization_definitions to MTL_PARAMETERS for bug 5051885

981:
982: begin
983: l_stmt_num := 20;
984:
985: -- changed from org_organization_definitions to MTL_PARAMETERS for bug 5051885
986: -- Performance issue on org_organization_definitions for full table scan on base tables
987: -- SQL id 16640485
988:
989: select organization_id

Line 991: from MTL_PARAMETERS

987: -- SQL id 16640485
988:
989: select organization_id
990: into p_org_id
991: from MTL_PARAMETERS
992: where organization_code = p_org_code;
993: -- bug 5051885
994: exception
995: when others then

Line 8754: mtl_parameters MP

8750: l_restrict_locators_code,
8751: l_item_loc_control
8752: FROM mtl_system_items MS,
8753: mtl_secondary_inventories MSUB,
8754: mtl_parameters MP
8755: WHERE MP.organization_id = v_wlji_org_id(v_idx)
8756: AND MS.organization_id = v_wlji_org_id(v_idx)
8757: AND MS.inventory_item_id = v_wlji_item_id(v_idx)
8758: AND MSUB.secondary_inventory_name

Line 9345: mtl_parameters MP

9341: l_restrict_locators_code,
9342: l_item_loc_control
9343: FROM mtl_system_items MS,
9344: mtl_secondary_inventories MSUB,
9345: mtl_parameters MP
9346: WHERE MP.organization_id = v_wlji_org_id(v_idx)
9347: AND MS.organization_id = v_wlji_org_id(v_idx)
9348: AND MS.inventory_item_id = v_wlji_item_id(v_idx)
9349: AND MSUB.secondary_inventory_name

Line 9491: mtl_parameters MP

9487: l_restrict_locators_code,
9488: l_item_loc_control
9489: FROM mtl_system_items MS,
9490: mtl_secondary_inventories MSUB,
9491: mtl_parameters MP
9492: WHERE MP.organization_id = v_wlji_org_id(v_idx)
9493: AND MS.organization_id = v_wlji_org_id(v_idx)
9494: AND MS.inventory_item_id = v_wlji_item_id(v_idx)
9495: AND MSUB.secondary_inventory_name

Line 11875: -- changed from org_organization_definitions to MTL_PARAMETERS for bug 5051885

11871: -- note that this is a rudimentary piece of commentary on the job created,
11872: -- or failed to create because there's no customer requirement on this.
11873: if v_wlji_load_type(v_idx) = 5 then
11874: l_stmt_num := 1040.1;
11875: -- changed from org_organization_definitions to MTL_PARAMETERS for bug 5051885
11876: -- Performance issue on org_organization_definitions for full table scan on base tables
11877: -- SQL id 16641913
11878:
11879: select organization_code

Line 11881: from MTL_PARAMETERS

11877: -- SQL id 16641913
11878:
11879: select organization_code
11880: into l_org_code
11881: from MTL_PARAMETERS
11882: where organization_id = v_wlji_org_id(v_idx);
11883: -- bug 5051885
11884: l_stmt_num := 1040.2;
11885: select meaning