DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on MTL_SECONDARY_INVENTORIES

Line 2548: from mtl_secondary_inventories

2544: /* ST bug fix 3722383 end */
2545:
2546: select locator_type
2547: into l_mtl_locator_type
2548: from mtl_secondary_inventories
2549: where secondary_inventory_name = p_completion_subinventory
2550: and organization_id = p_organization_id;
2551:
2552: /* ST bugfix3336844(2793501) call wip_locator.validate is enough for validate lcator: null or not. remove checks of

Line 2558: from mtl_secondary_inventories

2554: --control but sub is not. */
2555: /***
2556: select locator_type
2557: into l_mtl_locator_type
2558: from mtl_secondary_inventories
2559: where secondary_inventory_name = p_completion_subinventory
2560: and organization_id = p_organization_id;
2561:
2562: if p_completion_locator_id is not null then

Line 2571: mtl_secondary_inventories MSUB,

2567: MS.location_control_code item_loc_control
2568: into l_sub_loc_control, l_org_loc_control,
2569: l_restrict_locators_code, l_item_loc_control
2570: FROM mtl_system_items MS,
2571: mtl_secondary_inventories MSUB,
2572: mtl_parameters MP
2573: WHERE MP.organization_id = p_organization_id
2574: AND MS.organization_id = p_organization_id
2575: AND MS.inventory_item_id = p_assembly_item_id