APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 8645: from mtl_secondary_inventories

8641: -- }} validation of subinv end
8642: l_stmt_num := 330.2;
8643: select locator_type
8644: into l_mtl_locator_type
8645: from mtl_secondary_inventories
8646: where secondary_inventory_name
8647: = v_wlji_compl_subinv(v_idx)
8648: and organization_id = v_wlji_org_id(v_idx);
8649:

Line 8753: mtl_secondary_inventories MSUB,

8749: l_org_loc_control,
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)

Line 9268: from mtl_secondary_inventories

9264:
9265: l_stmt_num := 540;
9266: select locator_type
9267: into l_mtl_locator_type
9268: from mtl_secondary_inventories
9269: where secondary_inventory_name
9270: = v_wlji_compl_subinv(v_idx)
9271: and organization_id = v_wlji_org_id(v_idx);
9272:

Line 9344: mtl_secondary_inventories MSUB,

9340: l_org_loc_control,
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)

Line 9457: from mtl_secondary_inventories

9453:
9454: l_stmt_num := 590.4;
9455: select locator_type
9456: into l_mtl_locator_type
9457: from mtl_secondary_inventories
9458: where secondary_inventory_name
9459: = v_wlji_compl_subinv(v_idx)
9460: and organization_id = v_wlji_org_id(v_idx);
9461:

Line 9490: mtl_secondary_inventories MSUB,

9486: l_org_loc_control,
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)