330:
331: --Start 2878098 WIP Locator mandatory by loc contrl
332: CURSOR c_org_loc_control(cp_org_id number) IS
333: SELECT stock_locator_control_code,negative_inv_receipt_code
334: FROM mtl_parameters
335: where organization_id = cp_org_id;
336:
337: CURSOR c_subinv_loc_control(cp_org_id number,
338: cp_subinv_name varchar2) IS
902: from MTL_SYSTEM_ITEMS msi
903: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
904: and ORGANIZATION_ID in
905: ( select MASTER_ORGANIZATION_ID
906: from MTL_PARAMETERS
907: where ORGANIZATION_ID = MASTER_ORGANIZATION_ID )
908: and rownum = 1
909: and not exists
910: (select UNIT_OF_MEASURE