APPS.WSM_LBJ_INTERFACE_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 8547: from mtl_secondary_inventories

8543: -- }} validation of subinv end
8544: l_stmt_num := 330.2;
8545: select locator_type
8546: into l_mtl_locator_type
8547: from mtl_secondary_inventories
8548: where secondary_inventory_name
8549: = v_wlji_compl_subinv(v_idx)
8550: and organization_id = v_wlji_org_id(v_idx);
8551:

Line 8655: mtl_secondary_inventories MSUB,

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

Line 9170: from mtl_secondary_inventories

9166:
9167: l_stmt_num := 540;
9168: select locator_type
9169: into l_mtl_locator_type
9170: from mtl_secondary_inventories
9171: where secondary_inventory_name
9172: = v_wlji_compl_subinv(v_idx)
9173: and organization_id = v_wlji_org_id(v_idx);
9174:

Line 9246: mtl_secondary_inventories MSUB,

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

Line 9359: from mtl_secondary_inventories

9355:
9356: l_stmt_num := 590.4;
9357: select locator_type
9358: into l_mtl_locator_type
9359: from mtl_secondary_inventories
9360: where secondary_inventory_name
9361: = v_wlji_compl_subinv(v_idx)
9362: and organization_id = v_wlji_org_id(v_idx);
9363:

Line 9392: mtl_secondary_inventories MSUB,

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