APPS.WSMPLBJI dependencies on MTL_SECONDARY_INVENTORIES

Line 4092: from mtl_secondary_inventories

4088: -- validation of subinv end
4089:
4090: select locator_type
4091: into mtl_locator_type
4092: from mtl_secondary_inventories
4093: where secondary_inventory_name = v_wlji_completion_subinventory(v_index)
4094: and organization_id = v_wlji_org(v_index);
4095:
4096: if v_wlji_completion_subinventory(v_index) = l_default_subinventory then

Line 4194: mtl_secondary_inventories MSUB,

4190: MS.location_control_code item_loc_control
4191: into l_sub_loc_control, l_org_loc_control,
4192: l_restrict_locators_code, l_item_loc_control
4193: FROM mtl_system_items MS,
4194: mtl_secondary_inventories MSUB,
4195: mtl_parameters MP
4196: WHERE MP.organization_id = v_wlji_org(v_index)
4197: AND MS.organization_id = v_wlji_org(v_index)
4198: AND MS.inventory_item_id = v_wlji_item(v_index)

Line 5670: from mtl_secondary_inventories

5666:
5667: l_stmt_num := 700.5;
5668: select locator_type
5669: into mtl_locator_type
5670: from mtl_secondary_inventories
5671: where secondary_inventory_name = v_wlji_completion_subinventory(v_index)
5672: and organization_id = v_wlji_org(v_index);
5673:
5674: if v_wlji_completion_subinventory(v_index) = l_default_subinventory then

Line 5746: mtl_secondary_inventories MSUB,

5742: MS.location_control_code item_loc_control
5743: into l_sub_loc_control, l_org_loc_control,
5744: l_restrict_locators_code, l_item_loc_control
5745: FROM mtl_system_items MS,
5746: mtl_secondary_inventories MSUB,
5747: mtl_parameters MP
5748: WHERE MP.organization_id = v_wlji_org(v_index)
5749: AND MS.organization_id = v_wlji_org(v_index)
5750: AND MS.inventory_item_id = v_wlji_item(v_index)