APPS.WSMPLBJI dependencies on MTL_SECONDARY_INVENTORIES

Line 4098: from mtl_secondary_inventories

4094: -- validation of subinv end
4095:
4096: select locator_type
4097: into mtl_locator_type
4098: from mtl_secondary_inventories
4099: where secondary_inventory_name = v_wlji_completion_subinventory(v_index)
4100: and organization_id = v_wlji_org(v_index);
4101:
4102: if v_wlji_completion_subinventory(v_index) = l_default_subinventory then

Line 4200: mtl_secondary_inventories MSUB,

4196: MS.location_control_code item_loc_control
4197: into l_sub_loc_control, l_org_loc_control,
4198: l_restrict_locators_code, l_item_loc_control
4199: FROM mtl_system_items MS,
4200: mtl_secondary_inventories MSUB,
4201: mtl_parameters MP
4202: WHERE MP.organization_id = v_wlji_org(v_index)
4203: AND MS.organization_id = v_wlji_org(v_index)
4204: AND MS.inventory_item_id = v_wlji_item(v_index)

Line 5676: from mtl_secondary_inventories

5672:
5673: l_stmt_num := 700.5;
5674: select locator_type
5675: into mtl_locator_type
5676: from mtl_secondary_inventories
5677: where secondary_inventory_name = v_wlji_completion_subinventory(v_index)
5678: and organization_id = v_wlji_org(v_index);
5679:
5680: if v_wlji_completion_subinventory(v_index) = l_default_subinventory then

Line 5752: mtl_secondary_inventories MSUB,

5748: MS.location_control_code item_loc_control
5749: into l_sub_loc_control, l_org_loc_control,
5750: l_restrict_locators_code, l_item_loc_control
5751: FROM mtl_system_items MS,
5752: mtl_secondary_inventories MSUB,
5753: mtl_parameters MP
5754: WHERE MP.organization_id = v_wlji_org(v_index)
5755: AND MS.organization_id = v_wlji_org(v_index)
5756: AND MS.inventory_item_id = v_wlji_item(v_index)