APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_PARAMETERS

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

976:
977: begin
978: l_stmt_num := 20;
979:
980: -- changed from org_organization_definitions to MTL_PARAMETERS for bug 5051885
981: -- Performance issue on org_organization_definitions for full table scan on base tables
982: -- SQL id 16640485
983:
984: select organization_id

Line 986: from MTL_PARAMETERS

982: -- SQL id 16640485
983:
984: select organization_id
985: into p_org_id
986: from MTL_PARAMETERS
987: where organization_code = p_org_code;
988: -- bug 5051885
989: exception
990: when others then

Line 8656: mtl_parameters MP

8652: l_restrict_locators_code,
8653: l_item_loc_control
8654: FROM mtl_system_items MS,
8655: mtl_secondary_inventories MSUB,
8656: mtl_parameters MP
8657: WHERE MP.organization_id = v_wlji_org_id(v_idx)
8658: AND MS.organization_id = v_wlji_org_id(v_idx)
8659: AND MS.inventory_item_id = v_wlji_item_id(v_idx)
8660: AND MSUB.secondary_inventory_name

Line 9247: mtl_parameters MP

9243: l_restrict_locators_code,
9244: l_item_loc_control
9245: FROM mtl_system_items MS,
9246: mtl_secondary_inventories MSUB,
9247: mtl_parameters MP
9248: WHERE MP.organization_id = v_wlji_org_id(v_idx)
9249: AND MS.organization_id = v_wlji_org_id(v_idx)
9250: AND MS.inventory_item_id = v_wlji_item_id(v_idx)
9251: AND MSUB.secondary_inventory_name

Line 9393: mtl_parameters MP

9389: l_restrict_locators_code,
9390: l_item_loc_control
9391: FROM mtl_system_items MS,
9392: mtl_secondary_inventories MSUB,
9393: mtl_parameters MP
9394: WHERE MP.organization_id = v_wlji_org_id(v_idx)
9395: AND MS.organization_id = v_wlji_org_id(v_idx)
9396: AND MS.inventory_item_id = v_wlji_item_id(v_idx)
9397: AND MSUB.secondary_inventory_name

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

11767: -- note that this is a rudimentary piece of commentary on the job created,
11768: -- or failed to create because there's no customer requirement on this.
11769: if v_wlji_load_type(v_idx) = 5 then
11770: l_stmt_num := 1040.1;
11771: -- changed from org_organization_definitions to MTL_PARAMETERS for bug 5051885
11772: -- Performance issue on org_organization_definitions for full table scan on base tables
11773: -- SQL id 16641913
11774:
11775: select organization_code

Line 11777: from MTL_PARAMETERS

11773: -- SQL id 16641913
11774:
11775: select organization_code
11776: into l_org_code
11777: from MTL_PARAMETERS
11778: where organization_id = v_wlji_org_id(v_idx);
11779: -- bug 5051885
11780: l_stmt_num := 1040.2;
11781: select meaning